EXCEL表格里公式填写的格式
发布网友
共3个回答
热心网友
=if(and(a1<2.3,b1>75,b1<110),"*",if(and(a1>=2.3,a1<3.5,b1>75,b1<110),"B级","不合格"))
不知道还有别的标准没,比如不合格
热心网友
如下：
=IF(AND(B1<110,B1>75),IF(A1<2.3,"A",IF(AND(A1>2.3,A1<3.5),"B","其他")),"其他")
热心网友
C2=if(and(B2>75,B2<110),if(A2<2.3,"A",if(and(a2>2.3,A2<3.5),"B",""),"")
