Excel中如何对两个科目的分数进行划分等级？
发布网友
发布时间：2022-03-07 20:38
共3个回答
热心网友
时间：2022-03-07 22:07
假设语文在A列，则等级分语数英下H2单元格公式：
=LOOKUP(A2,{0,60,70,80,90;"E","D","C","B","A"})&LOOKUP(B2,{0,60,70,80,90;"E","D","C","B","A"})&LOOKUP(C2,{0,60,70,80,90;"E","D","C","B","A"})
将公式下拉即可
热心网友
时间：2022-03-07 23:25
=LOOKUP(C3,{0,60,70,80,90},{"E","D","C","B","A"})&LOOKUP(D3,{0,60,70,80,90},{"E","D","C","B","A"})&LOOKUP(E3,{0,60,70,80,90},{"E","D","C","B","A"})
C3、D3、E3分别是语文、数学、英语
热心网友
时间：2022-03-08 01:00
你上面描述条件混乱 80是B还是C？70是C还是D？
条件弄好之后IF判断下就可以了
