我在F2单元格里写了个判断公式,需要用到G2的值进行判断返回ABC等级,但是我这样写预览显示出来就是#NAME?
用逗号隔开的IF(g2>=95,'aa',if(g2>=85,'a',if(g2>=75,'b',if(G2>=60,'C','D'))))
if(G2>=95,"AA",if(G2>=85,"A",if(G2>=75,"B",if(G2>=60,"C","D"))))
先不说符号问题,这个逻辑貌似有点问题把。
应该是if(g2>=95,"AA",IF(AND(G2>=85,G2<95),"A",IF(AND(G2>=75,G2<85),"B",IF(AND(G2>=602,G2<75),"C","D"))))