ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Gªº¤½¦¡¼g¨ì¦¹¥d¦í¤F

Gªº¤½¦¡¼g¨ì¦¹¥d¦í¤F

Gªº¤½¦¡¼g¨ì¦¹¥d¦í¤F^^
½Ð·|ªº¤j¤jÀ°À°§Ú¦n¶Ü?
1. GªºFALSEµ²ªG¬°¡uA3 ¡v
2.¤½¦¡¥i¥H²¤Æ¶Ü¡H

¤ÀªR1.zip (129.94 KB)

¦^´_ 1# koala2099


=IF(AND(D3<$C$1,MOD(C3,{4,8})=0),"A4",IF(AND(D3<$C$1,MOD(C3,{2,6})>=0),"A2",IF(D3>$D$1,"A2","A3")))

TOP

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-5-20 15:05 ½s¿è

¦^´_ 2# register313

«D±`ÁÂÁ±zªºÀ°¦£~
¦ý~¥t¤@­Ó¡÷¸U¦ì¬°³æ¼Æ¡A¤d¦ì¤p©ó2000µ²ªGÀ³¬°A3
¦³»~¥þÅܦ¨A2¤F»Ý­nªºµ²ªG¬OA3¤~¹ï
¥i§_¦A¦¸³Â·Ð±z^^¨¯­W¤F~

¤ÀªR2.zip (155.08 KB)

TOP

¦^´_ 3# koala2099

§A¤£¬O¤]¼g¥X¤½¦¡¤F¶Ü

=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"))))

TOP

¦^´_ 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"))

TOP

¦^´_ 5# koala2099
¹ê¦b¤£ª¾¹D§Aªº¾ãÅé§PÂ_­ì«h¡A¹Ï¤¤²Ä99¦CÀ³¸Ó¬OA4©Î¬OA2?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD