[算表] 判斷儲存格內容回傳數值
軟體:excel
版本:2003
因為製作成績單的需要想請教..
若是儲存格內輸入：A+,A,A-,B+........
想要判斷輸入值而回傳級分：10.9.8.7......
要怎麼寫比較好??
小弟目前是使用LOOKUP..
在K5格子中想判斷J5輸入的值(A+)然後回傳6的值..
經過white306大大指導後改寫為...
=LOOKUP({"A+","A","A-"},J5,{"7","6","5"})
不過我不管輸入A+或是A或是A-都跑出7來..QQ
--
我發覺內心中的某處漸漸腐化..但是..我從未試著去阻止..
因為我逐漸發覺..那個腐化的部份..才是真正的我..
或許有一天你也會想到..究竟我們為何而戰？為誰而戰？
仔細去探索我們戰鬥的真正目的..竟然只是純粹為了喜好血腥罷了.. ~ 仙水忍 ~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 124.11.129.120
→
09/15 17:12, , 1F
09/15 17:12, 1F
※ 編輯: aderlilas 來自: 124.11.129.120 (09/15 17:28)
→
09/15 17:33, , 2F
09/15 17:33, 2F
→
09/15 17:34, , 3F
09/15 17:34, 3F
→
09/15 17:35, , 4F
09/15 17:35, 4F
→
09/15 17:38, , 5F
09/15 17:38, 5F
→
09/15 17:39, , 6F
09/15 17:39, 6F
→
09/15 17:43, , 7F
09/15 17:43, 7F
→
09/15 17:44, , 8F
09/15 17:44, 8F
→
09/15 17:44, , 9F
09/15 17:44, 9F
→
09/15 17:47, , 10F
09/15 17:47, 10F
→
09/15 17:49, , 11F
09/15 17:49, 11F
→
09/15 17:58, , 12F
09/15 17:58, 12F
→
09/15 17:58, , 13F
09/15 17:58, 13F
→
09/15 18:00, , 14F
09/15 18:00, 14F
→
09/15 18:01, , 15F
09/15 18:01, 15F
→
09/15 18:03, , 16F
09/15 18:03, 16F
→
09/15 18:13, , 17F
09/15 18:13, 17F
→
09/15 18:14, , 18F
09/15 18:14, 18F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
