烟懂我孤独 发表于 2021-11-10 07:37:00

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

考试分数转换为等级，下面的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:




其哥海鲜 发表于 2021-12-3 22:04:49

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

明心羊 发表于 2021-12-15 14:14:57

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

闲人很忙 发表于 2021-12-18 13:33:27

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

你的故事讲到了哪 发表于 2021-12-22 17:10:59

是不一样的，谢谢您

大當家 发表于 2022-1-15 18:29:55

非常感谢！

财经小白 发表于 2022-1-30 03:38:28

非常感谢！

唐僧洗头愛飄柔 发表于 2022-2-8 01:14:08

非常感谢了！！
页: [1]
查看完整版本: 考试分数转换为等级，有没有更简单的呀，请高手过来看下