本帖最后由 hsl215 于 2014-8-16 13:37 编辑
第一题第 二题- =IF(B18>20,4,IF(B18>10,3,2))/1%
- =IF(B18<11,2,IF(B18<21,3,4))/1%
- =LOOKUP(B18,{0,2;11,3;21,4})/1%
- =VLOOKUP(B18,{0,2;11,3;21,4},2)/1%
- =HLOOKUP(B18,{0,11,21;2,3,4},2)/1%
- =CHOOSE(MATCH(B18,{0,11,21}),2,3,4)/1%
- =INDEX({2;3;4},MATCH(B18,{0;11;21}))/1%
复制代码 第三题,还可以写出好几个,就不一一写出来了。- =IF(MOD(MID(B27,9,9),2),"男","女")
- =IF(MOD(MID(B27,15,3),2),"男","女")
- =IF(MOD(RIGHT(LEFT(B27,17)),2),"男","女")
- =TEXT(-1^MID(B27,9,9),"女;男")
- =TEXT(MOD(MID(B27,9,9),2),"男;;女")
- =CHOOSE(MOD(MID(B27,9,9),2)+1,"女","男")
- =CHOOSE(2^MOD(MID(B27,9,9),2),"女","男")
- =IF(ISODD(MID(B27,9,9)),"男","女")
- =IF(ISEVEN(MID(B27,9,9)),"女","男")
复制代码 第四题
公式格式应用于
=$A$36:$C$41
|