Question

excel中怎么用IF函数，如：等级评定标准

等级评定标准：期评成绩>=90为优，90>期评成绩>=80为良，80>期评成绩>=60为中，期评成绩<60为差

Answer 1

1、电脑打开Excel表格。

2、打开Excel表格后，输入公式=IF(D7>=90,"优",IF(D7>=80,"良",IF(D7>=60,"中","差")))。

3、输入公式=IF(D7>=90,"优",IF(D7>=80,"良",IF(D7>=60,"中","差")))后，按回车键即可评定等级。

4、最后下拉复制公式即可。

Answer 2

若“期评成绩”在A1格，“等级评定标准”在B1格，输入公式：
=if(A1>=90,"优",if(A1<60,"差",if(A1>=80,"良","中")))

Answer 3

=IF(A1<60,"差",IF(A1<80,"中",IF(A1<90,"良","优")))
=MID("差中良优",SUM(--(A1>={0;60;80;90})),1)
=MID("差中良优",MAX(IF(A1>={0;60;80;90},{1;2;3;4})),1)

Answer 4

假设期评成绩在A列
B2输入公式
=IF(A2>=90,"优",IF(A2>=80,"良",IF(A2>=60,"中","差")))
下拉填充公式即可

Answer 5

假设期评成绩在A列，等级在B列
B1=if(A1>=90,"优",if(A1>=80,"良",if(A1>=60,"中","差")))