[习题] 【函中习题08】精英培训网 201401函中条件判定专题

发表于 2014-8-7 10:43 | 显示全部楼层

=IF(B11>=85,"晋级","待定")
=IF(B30>=85,"晋级",IF(B30<75,"淘汰","待定"))
=IF(B49>=85%,"500",IF(B49<70%,"不奖励","200"))
=IF(AND(B68="营销部",C68>30%),"10000",IF(AND(B68="营销部",C68>25%),"5000",IF(AND(B68="营销部",C68>20%),"2000",IF(AND(B68="市场部",C68>25%),"10000",IF(AND(B68="市场部",C68>15%),"5000",IF(AND(B68="市场部",C68>10%),"2000","0"))))))

复制代码

参与人数 1	+9	收起理由
jio1ye	+ 9	赞一个!

1 2 34 / 4 页

GMT+8, 2024-5-17 06:50 , Processed in 0.234600 second(s), 7 queries , Gzip On, Yac On.

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

[习题] 【函中习题08】精英培训网 201401函中 条件判定专题