通常用IF函数可以嵌套7层。不够用的可以用“&”组合嵌套。
但如果你要实现这样，很简单，用LOOKUP函数：
B1输入
=LOOKUP(A1,{0,1,2,3,4,5,6,7,8,9},{"A","B","C","D","E","F","G","H","I","J"})回车
=LOOKUP(A1,{0,1,2,3,4,5,6,7,8,9},{"A","B","C","D","E","F","G","H","I","J"})
在B1输公式：=CHOOSE(A1,"B","C","D","E","F","G","H","I","J")
这个是最简单实用的
=IF((A1>=0)*(A1<=9),CHAR(A1+65),"")
b1=CHAR(A1+65)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024