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

excel¹ô§OÂà´«ªº°ÝÃD

excel¹ô§OÂà´«ªº°ÝÃD

½Ð°Ýexcel ­n¦p¦ó³]¤½¦¡.·í¤£¦P¹ô§O¼Æ¦r¿é¤J«á ¥i¥H³£Åܦ¨Åã¥Ü¬Û¦P¹ô§O

¦^´_ 1# jane0312000


´£°Ý­nª`·N¤£­n¤Ó²²¤,
½ÐÁ|´X­Ó¹ê¨Ò¨Ã¼ÒÀÀ©Ò­nªºµ²ªG, ³Ì¦n¤W¶ÇÀÉ®×!

TOP

¦^´_ 1# jane0312000

TOP

³f¹ô¬Ý°_¨Ó¬O¿é¤J¼Æ¦r«á¦A³]³f¹ô®æ¦¡¡AEXCEL¥u·|³æ¯Â³B²z¼Æ¦r
­n§PÂ_¹ô§OÁÙ±o§Q¥Î¯S®í¨ç¼Æ¥h¨ú¥X¡A·¥¬°³Â·Ð¡C
«Øij
¹ô§O¡Bª÷ÃB¡B§é¦X¬üª÷ ¦U¤@Äæ¡A¹ô§O°t¦X¹Ï¤¤¶¡¨º­Ó ¶×²v¹ï·Óªíªº¥Îµü
§é¦X¬üª÷ ¥i¥Îvlookup¥H¹ô§O¬d¸ß¶×²v¹ï·Óªí¦A´«ºâ

TOP

¦^´_ 4# KCC

½Ð°Ý¦³vlookupªº¤½¦¡¥i¥H®M¥Î¶Ü?
¤§«e¦³ÂsÄý¤峹 ´£¨Ñ¤F³o¼Ë¤@­Ó¤½¦¡ VLOOKUP(LEFT(A2,FIND("$",A2)-1),$E$1:$F$4,2,0)*MID(A2,FIND("$",A2)+1,255)
¦ý·|Åã¥Ü #VALUE!
ÁÂÁÂ

TOP

¦^´_ 5# jane0312000

µ¹§A¤@­Ó³Ì°ò¥»ªº§@ªk¡A¹ô§O¡Bª÷ÃB¤À¶}¿é¤J«á¬d¸ß´«ºâ

currency.jpg (23.19 KB)

currency.jpg

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD