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

新月gg · 发表于 2012-11-20 13:48

本帖最后由新月gg 于 2012-11-20 13:49 编辑

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

wuhairong2011 · 发表于 2012-11-20 13:52

本帖最后由 wuhairong2011 于 2012-11-20 14:06 编辑

【函初201203班】-D26-wuhairong2011
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
=LOOKUP(B4,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"})
=VLOOKUP(B4,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2,1)
=HLOOKUP(B4,{0,60,70,80,90;"不及格","及格","中等","良好","优秀"},2,1)

水上漂123 · 发表于 2012-11-20 13:57

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

hhl1984 · 发表于 2012-11-20 13:59

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

yjeeee · 发表于 2012-11-20 14:01

本帖最后由 yjeeee 于 2012-11-20 14:16 编辑

1,= IF(B4<60,"不及格",IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格",)))))
2,=LOOKUP(B4,{0,60,70,80,90;"不及格","及格","中等","良好","优秀"})

wawadai · 发表于 2012-11-20 14:01

本帖最后由 wawadai 于 2012-11-20 14:56 编辑

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

遗憾 · 发表于 2012-11-20 14:02

本帖最后由遗憾于 2012-11-25 17:41 编辑

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

hwc2ycy · 发表于 2012-11-20 14:03

【函数201203班】D25-hwc2ycy

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

复制代码

hhl1984 · 发表于 2012-11-20 14:07

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

huanran2000 · 发表于 2012-11-20 14:13

【函初201203班】-A21-HUANRAN2000
判断成绩
要求：小于60分的不及格，大于等于60分的及格，大于等于70的中等，大于等于80分的良好，大于等于90的优秀
姓名成绩判断
姓名1 89 良好
姓名2 60 及格
姓名3 57 不及格
姓名4 79 中等
姓名5 66 及格
姓名6 88 良好
姓名7 100 优秀
姓名8 93 优秀
姓名9 90 优秀
姓名10 41 不及格

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

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

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

【函初201203班]-E10-新月gg

评分

评分

评分

点评

点评

评分

点评

评分

点评

评分