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

¨ú2©Î6(¤Î¨âªÌ­¿¼Æ)¬°y

¨ú2©Î6(¤Î¨âªÌ­¿¼Æ)¬°y

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-5-17 22:27 ½s¿è

¦³¤è¦¡¥i¥H§¹¦¨¶Ü¡H
¨ú2©Î6(¤Î¨âªÌ­¿¼Æ)¬°y

¨ú2©Î6(¤Î2ªÌ­¿¼Æ)©µ¦ù.zip (9.26 KB)

¦^´_ 1# koala2099
«ü§PÂ_¸U¦ìªº­È¶Ü?
D2=IF(MOD(INT(A2/10000),{2,6})>0,"n","y")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-5-17 22:38 ½s¿è

¥t¥~©µ¦ù¥H60000¬°¼Ð·Ç­ÈA1¼Æ­È¬°58000~62000Åã¥Ü"y"¤£¬O«h¬°¡©n¡ª

TOP

¦^´_ 2# Hsieh

    ª¾¹DMOD¡BINT¦ý«o¤F¸Ñ¤£²`ÁÂÁ¶W¯Åª©¥D^^
¶â~­n§PÂ_¸U¦ì
¥t¥~©µ¦ù¥H60000¬°¼Ð·Ç­ÈA1¼Æ­È¬°58000~62000Åã¥Ü"y"¤£¬O«h¬°¡©n¡ª
¥i¥H½Ðª©¥DÀ°À°¦£¶Ü¡H

TOP

¦^´_ 4# koala2099
¬Ý¤£À´§A­nªí¹Fªº·N«ä
¬O¤¶©ó58000¨ì62000ªº­È´N¬Oyªº·N«ä¶Ü?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# koala2099

ÃD¥Ø¬O©Ç©Çªº

E2=IF(--RIGHT(A2,4)<=2000,"y","n")
E2=IF(ABS(A2-INT(A2/10000)*10000)<=2000,"y","n")
¥ý¸Õ¸Õ¬Ý ¹ï¤£¹ï

TOP

¦^´_ 6# register313
¦^´_ 5# Hsieh
ÕÙ~¬O©Ç©Çªº§Ú§x´b¤~¤W¨Ó¨D§U
¥ý¸Õ¸Õ¾ãÅé³s±µ«áªºµ²ªG
·PÁ¨â¦ìªºÀ°¦£

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD