比如A列可能是这些数值: 11 22 A34 44 55 66 77 88 99
我想在对应的B列用公式得到 A B C D E F G H I
就是当A1为11时,B1为“A”
当A1为22时, B1为“B”,
当A1为A34时, B1为“C”,以此类推。。(当为A34时,怎么办,出错了)
当A1为其它值时, B1为“WW”,
求B列这个函数怎么写???
=CHOOSE(SUM(({11,22,"A34",44,55,66,77,88,99}=A1)*{1,2,3,4,5,6,7,8,9})+1,"WW","A","B","C","D","E","F","G","H","I")
温馨提示:答案为网友推荐,仅供参考
第1个回答 2010-01-27
A34要用英文输入"A34"