考试分数转换为等级，有没有更简单的呀，请高手过来看下

烟懂我孤独

考试分数转换为等级，下面的if函数太长了，有没有更简单的呀，请高手过来看下，指教，感谢
100分制（道法、历史、物理、化学、生物、地理）分数转化为等级函数：
=IF(A2>=90,"A+",IF(A2>=85,"A",IF(A2>=80,"B+",IF(A2>=75,"B",IF(A2>=60,"C",IF(A2>=30,"D",IF(A2=90%
A:>=85%（优秀分数）
B+:>=80%
B:>=75%（良好分数）
C:>=60%（及格分数）
D:>=30-60%
E:
分数转换为等级函数.zip (6.56 KB, 下载次数: 14)

2021-11-10 07:37 上传

点击文件名下载附件
分数转换为等级函数.zip

其哥海鲜

=LOOKUP(A2,{0,30,60,75,80,85,90},{"E","D","C","B","B+","A","A+"})
90分 与 90%的应该是不一样的吧

明心羊

b2:
=LOOKUP(A2,{0,30,60,75,80,85,90},{"E","D","C","B","B+","A","A+"})

闲人很忙

100分=LOOKUP(A2,{0,30,60,75,80,85,90},{"E","D","C","B","B+","A","A+"})
120分=LOOKUP(E2,{0,36,72,90,96,102,108},{"E","D","C","B","B+","A","A+"})，
通用公式=LOOKUP(A2,{0,30,60,75,80,85,90}*多少分制度,{"E","D","C","B","B+","A","A+"})，三键结束，100分为1，120分为1.2

你的故事讲到了哪

是不一样的，谢谢您

大當家

非常感谢！

财经小白

非常感谢！

唐僧洗头愛飄柔

非常感谢了！！