本帖最后由 仅落恩 于 2014-8-21 08:47 编辑
- 1、=IF(C5>B5,B5,B5*95%)
- 2、=IF(B18>20,4,IF(B18>10,3,2))/1%
- =LOOKUP(B18,{0,2;11,3;21,4})/1%
- =INDEX({2;3;4},LOOKUP(B18,{0,1;11,2;21,3}))/1%
- =TEXT(B18,"[>20]4;[>10]3;2")/1%
- 3、=IF(ISODD(MID(B27,9,9)),"男","女")
- =IF(-(MID(B27,9,9))/2=INT(-(MID(B27,9,9))/2),"女","男")
- =IF(MOD(MID(B27,9,9),2),"男","女")
- =MID("女男",MOD(MID(B27,9,9),2)+1,1)
- =MID("女男",ISODD(MID(B27,9,9))+1,1)
- =CHOOSE(MOD(MID(B27,9,9),2)+1,"女","男")
- =TEXT(-1^MID(B27,9,9),"女;男")
- =TEXT(MOD(MID(B27,9,9),2), "男;;女")
- =LOOKUP(MOD(MID(B27,9,9),2),{0,1},{"女","男"})
- 4、选中A36:C41 条件格式 输入公式=if($$$$$$$$$$$$$$$$C36>$$$$$$$$$$$$$$$$B36,1)格式为黄色填充
复制代码 占楼看看是否设置 仅楼主可见
小系欺负人 好多好多的美元啊
咳 咳 附件上传中...
|