IF函数问题=IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,
IF函数问题
=IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=0,"D",IF(C2="未供货","未供货")))))）
如何当C2=未供货,我希望下面也输出个未供货,但是一直输出的是A,
=IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=0,"D",IF(C2="未供货","未供货")))))）
如何当C2=未供货,我希望下面也输出个未供货,但是一直输出的是A,
赞 共回答了23个问题采纳率：95.7% 举报
=IF(C2="未供货","未供货",IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,"C",IF(C2>=0,"D"))))))
1年前
5
可能相似的问题
-
1年前3个回答
-
1年前1个回答
你能帮帮他们吗