用excel评定成绩等级，该怎么做？IF函数只能嵌套7层，可我需要评11个，该怎么办？在线等答案，谢谢~

Question

等级划分如下：
90-100：A 　85-89：A- 　82-84：B+ 　　78-81：B 　　75-77：B- 　71-74：C+ 　　66-70：C 　　62-65:C- 　　60-61:D 　　60以下:F

Answer 1

分数在A1，评级在B1=IF(A1="","",LOOKUP(A1,{0,60,62,66,71,75,78,82,85,90;"F","D","C-","C","C+","B-","B","B+","A-","A"}))追问

呃......不对.....

追答

哪不对？上次我输入公式时少打一个"，现在调整好了。

追问

哦，嘿嘿，是我的问题，现在没事了，谢谢你啊~

Answer 2

假设你的分数在A1，要在B1得到结果。
在B1输入：
=LOOKUP(A1,{0,"F";60,"D";62,"C-";66,"C";71,"C+";75,"B-";78,"B";82,"B+";85,"A-";90,"A"})
下拉即可