excel中if函数不够用怎么办？高手赐教

Question

我要实现： A1等于0时，B1等于A
A1等于1时，B1等于B
A1等于2时，B1等于C
A1等于3时，B1等于D
A1等于4时，B1等于E
A1等于5时，B1等于F
A1等于6时，B1等于G
A1等于7时，B1等于H
A1等于8时，B1等于I
A1等于9时，B1等于J

Answer 1

通常用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"})回车

Answer 2

=LOOKUP(A1,{0,1,2,3,4,5,6,7,8,9},{"A","B","C","D","E","F","G","H","I","J"})本回答被提问者采纳

Answer 3

在B1输公式：=CHOOSE(A1,"B","C","D","E","F","G","H","I","J")

这个是最简单实用的

Answer 4

=IF((A1>=0)*(A1<=9),CHAR(A1+65),"")

Answer 5

b1=CHAR(A1+65)