excel表格设置

2025-02-25 06:25:57

推荐回答（5个）

回答1：

方法1：
=if(A1<60,"E",if(A1<74,"D",if(A1<84,"C",if(A1<94,"B","A"))))
方法2：
=LOOKUP(A12,{0,60,75,85,95},{"E","D","C","B","A"})
（至于包含非整数的，自己注意一下）

回答2：

既然你要套用的,就给你个套用的

假设,成绩数据在A列,在B1中输入以下内容,下拉

=IF(A1="","",IF(A1>=95,"A",IF(OR(A1={85,86,87,88,89,90,91,92,93,94}),"B",IF(OR(A1={75,76,77,78,79,80,81,82,83,84}),"C",IF(OR(A1={60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75}),"D",IF(A1<60,"E",))))))

回答3：

假设要输入公式的单元格在 A1，
=IF(A1>=95,"A",IF(A1>=85,"B",IF(A1>=75,"C",IF(A1>=60,"D",IF(A1<60,"E")))))

确认便可

回答4：

=IF(A1>94,"A",IF(A1>84,"B",IF(A1>74,"C",IF(A1>=60,"D","E"))))

回答5：

用EXCEL中的IF函数（条件函数）就能实现你这个问题