求高手指教excel if嵌套语句：如何实现>=3,<3,=0,<0,空值的分别处理，急！！

Question

也即：当L1>=3，显示A
L1<3，显示B
L1=0，显示C
L1<0，显示D
L1为空值，显示A
求高手指教，谢了！答案满意者可以追加分数

Answer 1

函数的话就用这个=IF(L1>=3,"A",IF(L1=0,"C",IF(L1<0,"D",IF(L1<3,"B"))))，如果是vba

就用if L1>=3 then
print "A";
else if L1<3 then
print "B"
else if L1=0 then
print "C"
else if L1<0 then
print "D"
else
print "A"

Answer 2

=IF(L1>=3,"A",TEXT(L1&"","!B;!D;C;A"))追问

按你的公式，结果如图啊，我的问题出在哪里？

追答

你的0是在L1单元格么。。

Answer 3

=if(L1>=3,"A",if(L1>0,"B",if(L1=0,"C",if(L1<0,"D","A"))))

Answer 4

=IF(L1>=3,"A",IF(L1=0,"C",IF(L1<0,"D",IF(L1<3,"B"))))本回答被提问者采纳