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

青山a

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

veryloveep

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

遗憾

遗憾 发表于 2012-11-20 14:02
=IF(B4

{:161:}                                                              

wangzan

=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))
【函初201203班]-F16-wangzan
=LOOKUP(B4,{0,60,70,80,90},{"不及格","及格","中等","良好","优秀"})

狐哥

【函初201203班】-F12-狐哥

单元格C4用以下公式，然后下拉：

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

复制代码

lixiaosi1986

【函初201203班】-E08-小四1986
在C4输入=IF(B4>=90,"优秀",IF(B4>=80,"良好",IF(B4>=70,"中等",IF(B4>=60,"及格","不及格"))))后下拉

蓝火雨

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

552314637

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

zjf1969

【函初201203班】-A组-A36:zjf1969
论坛ID:zjf1969
=IF(B4>=60,(IF(B4>=70,(IF(B4>=80,(IF(B4>=90,"优秀","良好")),"中等")),"及格")),"不及格")

xcslp

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