JLxiangwei 发表于 2012-4-23 12:17

【综合201201班】课前练习一

本帖最后由 JLxiangwei 于 2012-4-28 17:39 编辑


只能用IF函数完成

hwc2ycy 发表于 2012-4-23 12:23

辛苦了，学委。下题来了。

白米饭 发表于 2012-4-23 13:05

=IF(E3="A级","一级",IF(E3="B级","二级",IF(E3="C级","三级",IF(E3="D级","四级",IF(E3="E级","五级","")))))&IF(E3="F级","六级",IF(E3="G级","七级",IF(E3="H级","八级",IF(E3="I级","九级",IF(E3="J级","十级","")))))

happym8888 发表于 2012-4-23 13:13

**** Hidden Message *****

hwc2ycy 发表于 2012-4-23 13:36

=IF(E3=$A$3,$B$3,IF(E3=$A$4,$B$4,IF(E3=$A$5,$B$5,IF(E3=$A$6,$B$6,IF(E3=$A$7,$B$7,"")))))&IF(E3=$A$8,$B$8,IF(E3=$A$9,$B$9,IF(E3=$A$10,$B$10,IF(E3=$A$11,$B$11,IF(E3=$A$12,$B$12,"")))))

F3单元格公式，向下拉填充就行了。

金刚 发表于 2012-4-23 13:44

练习一下，好久不用生疏了

水吉果果 发表于 2012-4-23 13:44

本帖最后由 水吉果果 于 2012-4-23 13:46 编辑

水吉果果完成练习一，请学委审核{:1_1:}

sunnygy 发表于 2012-4-23 14:35

=IF(E12="A级","一级",IF(E12="B级","二级",IF(E12="C级","三级",IF(E12="D级","四级",IF(E12="E级","五级",IF(E12="F级","六级",))))))&IF(E12="G级","七级",IF(E12="H级","八级",IF(E12="I级","九级",IF(E12="J级","十级",))))

bel_joe 发表于 2012-4-23 20:04

我的练习一，老师指教。{:1_1:}

灬灬草缘灬灬 发表于 2012-4-23 20:53

页: [1] 2
查看完整版本: 【综合201201班】课前练习一