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

[µo°Ý] ³f¹ôÂà´«? ¤H¥Á¹ô©Î¬üª÷©Î´ä¹ô´«ºâ¦¨¥x¹ô

[µo°Ý] ³f¹ôÂà´«? ¤H¥Á¹ô©Î¬üª÷©Î´ä¹ô´«ºâ¦¨¥x¹ô

¦bExcel ­pºâ¦¨¥»¤Î³æ»ù®É, ¸g±`·|¹J¨ì±qERP¨t²ÎÂà¥X¨ÓªºEXCEL ªí®æ¤º¦³¤£¦P¹ô­È, ex. RMB$, US$, HK$.  ¤§«e±Ä¨úªº¤è¦¡³£¬O¥ý¿z¿ï¥X¦P¤@¹ô§O, ¦A¥h´«ºâ¦¨¥x¹ô.  ¬O§_¦³¤½¦¡¥i¥H¤@¦¸±N¤£¦Pªº¹ô§OÂà´«¦¨¦P¤@³f¹ô?  ¤§«e¬Ý¹L¦P¨Æ¬O±Ä¥Î¥¨¶°¨Ó¶i¦æ.  ¤£¹L, ¦P¨Æ³]ªº¥¨¶°§Úµ¹§Ñ¤F, ¤£ª¾¦s­þ¥h¤F...½Ð±Ð¥ý¶i´£ÂI¤@¤U. ÁÂÁÂ.

ex.

Cost         NT$
HK$100      ="HK$100"/4.2
US$3.5       ="US$3.5"/29.5
RMB$7        ="RMB$7"/5

³Ì¦n½T©w³f¹ô²Å¸¹¬O¤â¤u¿é¤JªºÁÙ¬OÀx¦s®æªº®æ¦¡³]©w
§_«hµL±q¤U¤â

TOP

¬JµM¬OERP¨t²ÎÂà¥X¨Óªº¡A´N¤£·|¬OÀx¦s®æªº®æ¦¡³]©w¤F¡A·íµM¤]¤£·|¬O¤â¤u¿é¤Jªº¡C
¶·­n§Ë²M·¡ªº¬O¡AÀx¦s®æ¤¤¬O§_§t¦³¤£©ú¦r¤¸¦b¤º¡C

TOP

¦^´_ 1# eunice_chuang
­n¦³¶×²v¹ï·Óªí
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-3-28 15:14 ½s¿è

=-LOOKUP(1,-RIGHT(A1,ROW($A$1:$A$10)))*CHOOSE(IF(ISNUMBER(FIND("HK$",A1)),1,IF(ISNUMBER(FIND("US$",A1)),2,3)),4.2,29.5,5)

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD