IF函数问题=IF(C2>=95,"A",IF(C2>=90,"AB",IF(C2>=80,"B",IF(C2>=70,

jiangfeng07242022-10-04 11:39:541条回答

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,

已提交，审核后显示！提交回复

_blqk83fi_f_1f4c 共回答了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年前