假设A1是成绩，B1公式：
=if(A1<70,"D",if(A1<80,"C",if(A1<90,"B","A")))
用IF函数做，单元格输入=if(a1>89,"A",if(a1>79,"B",if(a1>69,"C",If(a1>59,"D","E"))))
希望能帮到你！！
=IF(A1="缺考","缺考",IF(A1>89,"A",IF(A1>79,"B",IF(A1>69,"C",IF(A1>59,"D","E")))))
=LOOKUP(A1,{0,60,70,80,90},{"E","D","C","B","A"})
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024