excel的if函数（求各位大侠帮我写这条函数）附图一张

Question

问题⑴在“工资等级”列用IF函数求出每位职工的工资等级，当工资大于4000，工资等级为 “高工资”，工资大于等于3000且小于等于4000，工资等级为“中等”，否则为“低工资”；

Answer 1

F2公式下拉：

=IF(D2>4000,"高工资",IF(D2>=3000,"中等","低工资"))

或者用这公式也行：

=IF(D2<3000,"低工资",IF(D2<4001,"中等","高工资"))

再或者用这公式也行：

=LOOKUP(D2,{0;3000;4001},{"低工资";"中等";"高工资"})

还可以加入防空白判断，当D列为空白，即还没有输入工资金额时，公式也返回空白值。

=IF(D2="","",IF(D2>4000,"高工资",IF(D2>=3000,"中等","低工资")))

=IF(D2="","",LOOKUP(D2,{0;3000;4001},{"低工资";"中等";"高工资"}))

=IF(D2="","",IF(D2<3000,"低工资",IF(D2<4001,"中等","高工资")))