請問Excel中用IF多條件判斷式有else用法嗎- Yahoo!奇摩知識+

我想在EXCEL中下多條件判斷. 條件有四種. IF "甲" 則顯入"A" IF "乙" 則 ... 假設"甲乙 丙其他"填在A1，而B1=IF(A1="甲" ,"A",IF(A1="乙" ,"B",IF(A1="丙" ...

tw.knowledge.yahoo.com