用EXCEL怎么求等级啊，？

Question

如题所述

Answer 1

材料/工具：Excel2010

1、打开Excel2010表格，输入需要设置的数字。以下面表格数据为例

3、进入后点击【C2】单元格

3、输入等级公式【=IF(B2>=85,"优",IF(B2>=74,"良",IF(B2>=60,"及格","不及格"))) 】这里设置B列的成绩大于等于85分的等级为优，大于等于74等级为良，大于等于60等级为及格，剩下的等级是不及格

4、按回车键C2单元格就会出现【B2】单元格对应的等级

5、点击【C2】单元格，在右下方出现【实心加号】

6、鼠标下拉到【C11】

7、B列对应的等级就都出现了

Answer 2

1.最简单的是用if函数：
=if(a1<60,"不及格",if(a1<75,"中等",if(a1<85,"良好","优秀")))
2.此外也可以用lookup函数：
=lookup(a1,{0,60,75,85},{"不及格","中等","良好","优秀"})

Answer 3

使用下列公式之一
=LOOKUP(A2,{0,60,80,90},{"D","C","B","A"})
或
=LOOKUP(A1,{0,"D";60,"C";80,"B";90,"A"})
或
=IF(A2<60,"D",IF(A2<80,"C",IF(A2<90,"B","A")))
或
=IF(A2>=90,"A",IF(A2>=80,"B",IF(A2>=60,"C","D")))

Answer 4

=CHOOSE(IF(M2<60,1,IF(M2<80,2,IF(M2<90,3,4))),"D","C","B","A")
然后下拉填充柄
或者
=LOOKUP(M2,{0,60,80,90},{"D","C","B","A"})

Answer 5

=IF(A2<60,"D",IF(A2<80,"C",IF(A2<90,"B","A")))

本回答被提问者采纳