- ©«¤l
- 58
- ¥DÃD
- 21
- ºëµØ
- 0
- ¿n¤À
- 97
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-2-28
- ³Ì«áµn¿ý
- 2024-10-3
|
¦^´_ 4# register313
=IF(AND(C3<$B$1,MOD(B3,{4,8})=0),"A4",IF(AND(C3<$B$1,ISODD(B3)),"A3",IF(AND(C3<$B$1,MOD(B3,{2,6})>=0),"A2",IF(C3>$C$1,"A2","A3"))))
´o³U¥d¦í¤FÁ`·Q¤£¥X
¥u¦n°µ®»e=FALSE¤~¶Ç¦^nªº¸ê®Æ
=IF(AND(E9=FALSE,C9>$D$1),"A2",IF(AND(C9<$C$1,MOD(INT(B9)-1,{2,6})>=0),IF(AND(C9<$B$1,MOD((B9),{4,8})=0),"A4",IF(C9<$B$1,IF(MOD(INT(B9),{2,6})>0,"A3","A2"))),"A2")) |
|