【函数初级201203班】练习1---IF函数(已开贴)

zxh_273 · 发表于 2012-11-20 14:55

【函初201203班】-F01-zxh_273
=IF(B4<60,"不及格",IF(B4<70,"及格",IF(B4<80,"中等",IF(B4<90,"良好","优秀"))))

玫瑰vs刺 · 发表于 2012-11-20 14:56

在C4输入
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
下拉即可

moyanzhiai · 发表于 2012-11-20 14:59

=IF(B5>=90,"优秀",IF(B5>=80,"良好",IF(B5>=70,"中等",IF(B5>=60,"及格","不及格"))))
函初201203班C33 【函初3.C33】moy C33:moyanzhiai

hongqiqqq · 发表于 2012-11-20 15:11

已经做完，请审批。

xiaobai83 · 发表于 2012-11-20 15:13

本帖最后由 xiaobai83 于 2012-11-20 16:44 编辑

=IF(B4<60,"不及格",IF(B4<70,"及格",IF(B4<80,"中等",IF(B4<90,"良好","优秀"))))
还可以用VLOOKUP函数：
=VLOOKUP(B4,N:O,2,1)

Laphe · 发表于 2012-11-20 15:15

【函数201203班】-B33-Laphe

Joyce_chen · 发表于 2012-11-20 15:32

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))

【函数初级201203班】-C21-Joyce_chen

ynwevip · 发表于 2012-11-20 15:41

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
【函初201203班】-E24-ynwevip

awake2002 · 发表于 2012-11-20 15:58

【函初201203班】-B12-awake2002

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))

闪闪星儿 · 发表于 2012-11-20 16:04

【函初201203班】-A29-闪闪星儿

答：C4中输入公式：=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))，下拉填充。

		自动登录	找回密码
密码			注册

[习题] 【函数初级201203班】练习1---IF函数(已开贴)