excel分等级优秀,良好,及格,不及格,利用IF函数(单元格的绝对引用)计算...答:1、首先在excel表格中输入姓名和对应的分数,需要根据分数计算出等级。2、然后在C2单元格中输入函数公式,=IF(B2>=90,"优秀",IF(AND(B2>=80,B2<90),"良好",IF(AND(B2>=60,B2<80),"及格",IF(B2<60,"不及格"))),其中的分数设定可以根据不同的需要自行修改。3、点击回车即可生成函数计算...
excel大于等于90显示a答:=IF(A1>=100,"A",IF(A1>=90,"B",IF(A1>=80,"C",IF(A1>=70,"D",IF(A1>=60,"E","F")))通过IF函数嵌套,像剥洋葱一样逐层判断A1数值所在的区间,并返回对应的结果。大于等于100,返回“A”,大于等于90,返回“B”,大于等于80,返回“C”……这个公式的优点是易于理解,缺点是...
请教EXCEL公式, 如图A列小于80%的B列显示-200, A列大于85%的B列显示...答:使用下列公式之一 =LOOKUP(A1,{0,80,85}%,{-200,"",200})或 =IF(A1<0.8,-200,IF(A1>0.85,200,""))或 =IF(A1>0.85,200,IF(A1<0.8,-200,""))或 =IF(AND(A1>=0.8,A1<=0.85),"",IF(A1<0.8,-200,200))或 =IF(AND(A1>=0.8,A1<=0.85),"",IF(A1>0.85,...
如何用excel函数表示大于12个条件赋值比如,大于90显示a 大于80显示b...答:给你个例子吧。下面是我用过的大于等于90显示优秀,80-89显示良好,等等 =IF(M5>=89.95,"优秀",IF(M5>=80,"良好",IF(M5>=60,"及格","不及格")))式子中M5是你输入的分数。你可以改成 =IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C",IF(A1>=60,"D","E")))...