EXCEL FORMULA

2010-05-23 7:01 am
在下表中,ITEM 5 AND 6 的公式(LOOKUP)和其他ITEMS 是一樣的,用MINIMUM 找出ANSWER。 但ITEM 5 AND 6卻找不出正確的ANSWER, 公式應怎樣SET呢?

ItemPRICE 1PRICE 2PRICE 3PRICE 4PRICE 5ANSWERMINIMUM
10.2190.0730.0390.0630.087PRICE 30.039
21.6710.4660.4240.7770.507PRICE 30.424
31.7960.5290.4751.1650.562PRICE 30.475
41.7800.5190.3000.5560.548PRICE 30.300
55.6400.7801.0002.9801.800#N/A0.780
65.7330.9931.1172.8971.847#N/A0.993
71.7800.3810.2230.5560.392PRICE 30.223
80.1750.0580.0280.0480.087PRICE 30.028

回答 (1)

2010-05-23 4:47 pm
✔ 最佳答案
=INDEX($B$1:$F$1,MATCH(H2,B2:F2,0))

公式下拉

請參考附件:http://www.FunP.Net/741852



收錄日期: 2021-04-27 15:23:20
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100522000051KK01759

檢視 Wayback Machine 備份