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

[µo°Ý] excel ¤p°ÝÃD.. ¦³¹ê¨Ò

[µo°Ý] excel ¤p°ÝÃD.. ¦³¹ê¨Ò

¦pªG¦bA1¤¤¿é¤J=B1
¦ÓB1 ¨S¦³¿é¤J¥ô¦óªF¦è
A1 ·|Åã¥Ü0
¦p¦ó§âA1¤¤ªº0¥h±¼(§Y§¹¥þ©MB1¬Û¦P,B1¨S¦³¨S¦³¿é¤J¥ô¦óªF¦è,A1¤]¨S¦³Åã¥Ü¥ô¦óªF¦è)

ªþ¤W¹ê¨Ò
testing.zip (12.44 KB)
¤£¹L¹ê¨Òªº±¡ªp¤ñ¸û½ÆÂø, ±æ¦U°ª¤â¯àÀ°¦£¤@¤U
-------
¦pªG¥Î¨ä¥L¤èªk¤]¯à°µ¨ì¹ê¨Ò¤¤ªº±¡ªp¤]¥i
ÁÂÁ¤j®a

¦^´_ 1# wislltiaem


    A1=IF(ISNUMBER(B1),B1,"")

TOP

­n¬Ý B1 ªº¥Î³~¬O¤å¦rÁÙ¬O¼Æ­È
¼Æ­È:
A1=IF(ISNUMBER(B1),B1,"")

¤å¦r:
A1=T(B1)

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-8-8 13:35 ½s¿è

=TEXT(INDEX(Sheet2!$A$1:$E$11,($E$2=1)*($E$4=1)*1+($E$2=1)*($E$4=2)*4+($E$2=2)*($E$4=1)*7+($E$2=2)*($E$4=2)*10,COLUMN(A1)),"0;-0;;@")

TOP

¦^´_ 1# wislltiaem


   ÀÉ®×/¿ï¶µ/¶i¶¥
±N"¨ã¦³¹s­È±oÀx¦s®æÅã¥Ü¹s­È"¨ú®ø¤Ä¿ï
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ wislltiaem ©ó 2012-8-8 18:02 ½s¿è

ÁÂÁ¤j®a ¤j®aªº¤èªk¯à¥Î

¦ý¬O¦pªG¦n¹³¤U¹Ïªº±¡ªp

D3¦³­^¤å¦rAAAAAAAAAAA, E3¨S¦³¿é¤J¥ô¦ó¦r
¦ÓD6=D3, E6=E3
E6ªº0³Q¤j®a´£¥Xªº¤èªk¥h±¼
¦ýD6¥i¤£¥i¹³D3¤@¼Ë, ©Ò¦³ªºA¦r·|Åã¥Ü¥X¨Ó(¬ï¹LCELL¤]¥i)
ÁÂÁÂ

untitled.JPG (121.4 KB)

untitled.JPG

TOP

¦^´_ 6# wislltiaem

EXCEL¤£¯à¹F¨ì¦¹¥Øªº
¥u¯à¦b¤½¦¡­pºâ§¹«á¨Ï¥Î¦Û°Ê´«¦C©Î¬OÁY¤p¦Û¦æ¥H°t¦XÄæ¼e¨ÓÀ˵ø
    play.gif
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# Hsieh

ÁÂÁÂ

TOP

­n¬Ý B1 ªº¥Î³~¬O¤å¦rÁÙ¬O¼Æ­È
¼Æ­È:
A1=IF(ISNUMBER(B1),B1,"")

¤å¦r:
A1=T(B1)
¯«µLªk«I¥Çªº¥@¬É

TOP

ÁÂÁÂ,¤S¾Ç¨ì,¥i±Nµ{¦¡¼gµuÂI

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD