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

greatgto

回复要怎么设置啊！！！

surfan

【函初201203班】-A20-surfan


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

风过无声

[函初201203班]-D02-风过无声
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))

遗憾

做作业咯               

tbcdmp

D13—tbcdmp

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

laoda1228

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

回复的人好快啊。 想了半天才弄出来。

昨天今天明天

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

复制代码

【函数初级201203班】-A14-昨天今天明天

965502110

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

jerryzhouah

【函初201203班]-A10-jerryzhouah-今天

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

augustzhu1983

【函初201203班】-B29-augustzhu1983
=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,1)
=HLOOKUP(B4,{0,60,70,80,90;"不及格","及格","中等","良好","优秀"},2,1)
=CHOOSE((B4>=0)+(B4>=60)+(B4>=70)+(B4>=80)+(B4>=90),"不及格","及格","中等","良好","优秀")
=CHOOSE(IF(B4<60,6,B4/10-5),"及格","中等","良好","优秀","优秀","不及格")