分数在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"}))
假设你的分数在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"})
下拉即可
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024