ªð¦^¦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)

¥»©«³Ì«á¥Ñ 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

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

        ÀR«ä¦Û¦b : ¤f»¡¦n¸Ü¡B¤ß·Q¦n·N¡B¨­¦æ¦n¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD