excel文字與數字對照+10 - Yahoo!奇摩知識+

目前想要設定我在A1輸入X，B1就會出現35，還有A1輸入Y，B1就會出現 ... =IF(A1=" X",35,IF(A1="Y",32,IF(A1="Z",80,""))) ... =LOOKUP(A1,{0,"X","Y","Z" ...

tw.knowledge.yahoo.com