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

½Ð±Ð

¦^´_ 1# 198188

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  Hsieh


½Ð°Ý¬°¤°»ò§Ú¦V¤Ucopy,³W«h¦³¨Ç¸ò¦C¼ÆÅܧó¡A¦³¨Ç¤£·|¦Û°Ê¸ò¦C¼ÆÅܧóÁÙ¬O²Ä3¦C¡H
¥t¥~¥i ...
198188 µoªí©ó 2012-12-16 09:28

½Ð°Ý¬°¤°»ò§Ú¦V¤Ucopy,³W«h¦³¨Ç¸ò¦C¼ÆÅܧó¡A¦³¨Ç¤£·|¦Û°Ê¸ò¦C¼ÆÅܧóÁÙ¬O²Ä3¦C¡H
1¡Bª`·N³]©w®É§@¥Î¤¤Àx¦s®æ»P¤½¦¡ªº°Ñ·ÓÃö«Y
2¡B¬O§_¥i³]©w?
=(ISNUMBER(FIND("TT",$T2))*($U2<0))+($U2="")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# 198188


    §â§AªºÀɮפW¶Ç¬Ý¬Ý¡A§_«h¤£ª¾¹D¬O­þ¸Ì¥X°ÝÃD
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 7# 198188


    ³o¤£¬O¦³±o¨ì§A­nªº®ÄªG¶Ü?
³o¬O2003»P·sª©¤£¦Pªº¦a¤è
2007ª©¥H«á¡A§A¥i¯à¤£·|¬Ý¥X¬Û¹ï°Ñ·ÓªºÅܤơA
¦ý¦]¬°¦³¡i®M¥Î¨ì¡jªº½d³ò¡A
EXCEL¦Û°Ê·|¥H³]©w®É­Ôªº¬Û¹ïÃö«Yª½±µ®M¥Î¨ì½d³ò¤º
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 9# 198188


    Àx¦s®æ¤º®e¨Ã¤£¬Û¦P
L27=15.12
M27=15.1199999
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 11# 198188

=($M2<>" ")*($L2<>$M2)
§ï¦¨
=($M2<>"")*($L2<>$M2)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦¨´N¤@¤Á¡j®É¶¡¥i¥H³y´N¤H®æ¡A¥i¥H¦¨´N¨Æ·~¡A¤]¥i¥HÀx¿n¥\¼w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD