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

koala2099

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

register313

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

koala2099

¦^´_ 2# register313

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

register313

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

koala2099

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

Hsieh

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

¤U¸ü (33.36 KB)

2012-5-20 22:57