Excel中，用公式表现等级，如果90分以上是A，80-89是B以此类推

Question

如上，就是想在Excel中表现这个等级，我自己写了一个=IF(G5>=90,"A",AND(G5>=80,G5<=89,"B",IF(70>=G5>=79,"C",IF(60>=G5>=69,"D",IF(G5<=59,"E")))))不对，在线等！急！！

Answer 1

输入
=IF(G5>=90,"A",IF(G5>=80,"B",IF(G5>=70,"C",IF(G5>=60,"D","E"))))
或者输入
=LOOKUP(G5,{0,60,70,80,90},{"E","D","C","B","A"})

Answer 2

这个公式是平行的
稍等 我给你编辑一个
=IF(A1>=90,"A",IF(A1>=80,"B",IF(A1>=70,"C",IF(A1>=60,"D",IF(A1<=59,"E",)))))

下边那个朋友的公式更好