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

小草白云

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
F30:小草白云

想致富

【函初201203班]-F22-想致富
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格",IF(B4<60,"不及格")))))

lucking551

【函初201203班】-组学号-论坛ID

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

复制代码

玫瑰vs刺

玫瑰vs刺 发表于 2012-11-20 14:56
在C4输入
=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
下拉即可 ...

偶是A10:lw2294，嘿嘿

ct126_ct

=IF(B4<60,"不及格",IF(B4>=60,"及格",IF(B4>70,"中等",IF(B4>80,"良好",IF(B4>=90,"优秀")))))      【函初201203班]-E31-ct126_ct

seabearlin

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

wangjianff

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

小草白云

=IF(B4<60,"不及格",IF(B4<=70,"及格",IF(B4<=80,"中等",IF(B4<=90,"良好","优秀"))))
201203班F30:小草白云

小草白云

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
初函201203班,F30:小草白云

天使之翼

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

【函初201203班】F10：天使之翼