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

[µo°Ý] ½Ð°Ý¦p¦ó®æ¦¡³]©w¤G

[µo°Ý] ½Ð°Ý¦p¦ó®æ¦¡³]©w¤G

½Ð°Ý¦p¦ó®æ¦¡³]©w

®æ¦¡³]©w2.rar (3.48 KB)

jeason

¦^´_ 1# brabus


¬Ý¬Ý¬O¤£¬O±z»Ý­nªº
="¤å¦r"&IF(D6="¬ü¤¸",TEXT(C12*C6,"#,##0"),TEXT(C6,"#,##0"))&"¤å¦r"
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

µLªk¥H¦Û­q®æ¦¡Åã¥Ü,­n¥H¤½¦¡±o¨ì¦r¦ê
C16=TEXT(IF(D6="¬ü¤¸",1,C12)*C6,"§A¦s¤Jªº¬O###,###"&D6)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

µLªk¥H¦Û­q®æ¦¡Åã¥Ü,­n¥H¤½¦¡±o¨ì¦r¦ê
C16=TEXT(IF(D6="¬ü¤¸",1,C12)*C6,"§A¦s¤Jªº¬O###,###"&D6)
Hsieh µoªí©ó 2010-9-5 22:05



    ½Ð°Ý°ª¤â
¦pªG§Ú¦³­n10ºØ¹ô§Oªº¿ï¶µªº¸Ü
¤S­n«ç»ò¿ì©O
jeason

TOP

¦^´_ 4# brabus


    ¨º¥u­n§A¶×²v·|°w¹ï¹ô§O§ó°Ê´N¦æ
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¤F¸Ñ¤F,ÁÂÁ¦U¦ìªº¦^µª
jeason

TOP

¦^´_ 5# Hsieh


    §Ú¤S¦³°ÝÃD¤F,¦]¬°C16=TEXT(IF(D6="¬ü¤¸",1,C12)*C6,"§A¦s¤Jªº¬O###,###"&D6)
   ¤¤¤v¸g­­¨î¤F¼Æ¦rªº¼Æ¦r¥u¯à¦³6¦ì¼Æ
    ¥i¬O¸U¤@¥L¦s¶i¨Óªº¿ú¶W¹L6¦ì¼Æ,¥´¤ñ¤è1000¸U,¨º¤£´N±¾¤F,¦ì¼Æ¥i§_¦³¼u©Êªº,¨Ì¿ú¦h¤Ö½Õ¾ã
    ¦³¥i¯à¦³¤H·|¦s500¤¸,¦³¤H·|¦s1500¸U,¤£¯à©T©w³]6¦ì¼Æ
    ÁÂÁ°ª¤â«ü±Ð
jeason

TOP

¦^´_ 7# brabus


    §Ú¤£ª¾¹D§A¦³¨S¦³À³¥Î¬Ý¬Ý
°ò¥»¤W§Aªº·Qªk¬O¿ùªº
ÀH§A¥´¤J¦h¤Ö¿ú¥L³£·|À°§A­pºâªº
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Úª¾¹D¿ù¤F
¦pªG¬O³]000,000ªº¸Ü¤~¬O6¦ì¼Æ
¦pªG¬O###,###ªº¸Ü´N·|¦Û¤vÅܤÆ
ÁÂÁÂHsieh ªº«ü¥¿
jeason

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD