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

gdstcyzzt · 发表于 2012-11-20 14:18

各位老师，是这样吗？？？{:091:}

xsl343866865 · 发表于 2012-11-20 14:18

本帖最后由 xsl343866865 于 2012-11-20 14:24 编辑

[函数初级201203班]-D24-xsl343866865

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

复制代码

gdstcyzzt · 发表于 2012-11-20 14:20

【函初201203班】-E34-gdstcyzzt

各位老师是这样吗？？
=IF(B4<60,"不及格",IF(B4<70,"及格",IF(B4<80,"中等",IF(B4<90,"良好",IF(B4>=90,"优秀")))))

石磊. · 发表于 2012-11-20 14:20

【函初201203班]-B05:石磊.
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>70,"中等",IF(B4>=60,"及格","不及格"))))

xuyouxm · 发表于 2012-11-20 14:25

【函初201203班]-A01-xuyouxm.

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

复制代码

9201225 · 发表于 2012-11-20 14:27

本帖最后由 9201225 于 2012-11-20 15:15 编辑

【函初201203班】-C12-9201225

=IF(B4>=60,IF(B4>=70,IF(B4>=80,IF(B4>=90,"优秀","良好"),"中等"),"及格"),"不及格")
复制代码
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
复制代码
=LOOKUP(B4,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"})
复制代码
=LOOKUP(B4,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"})
复制代码
=VLOOKUP(B4,{0,"不及格";60,"及格";70,"中等";80,"良好";90,"优秀"},2)

复制代码

yanyupingsheng · 发表于 2012-11-20 14:41

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

新华人家 · 发表于 2012-11-20 14:44

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

graceli721 · 发表于 2012-11-20 14:47

函初201203班
F31 ID:graceli721
=IF(B4<60,"不及格",IF(B4<=69,"及格",IF(B4<=79,"中等",IF(B4<=89,"良好","优秀"))))

graceli721 · 发表于 2012-11-20 14:54

函初201203班
F31 ID:graceli721
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))

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

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

点评

评分

评分

评分

评分

评分

评分

评分

评分

评分