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

[µo°Ý] ¹ô§O§PÂ_

[µo°Ý] ¹ô§O§PÂ_

¦b¿é¤J¼Æ­Èªº®É­Ô¡A¥i¥H±qÀx¦s®æ®æ¦¡ªº(³f¹ô)©Î(·|­p±M¥Î)Ãþ§O¤¤¿ï¨ú¹ô§O¡A
¦ý¬OExcel ¦ü¥G¨S¦³¿ìªk§PÂ_¨ä¹ô§O¡A½Ð±Ð¬O¤£¬O¥²¶·¦A¥[¤@­ÓÄæ¦ìµù°O¹ô§O¡A¤~¯à§@¬°«áÄò¹ô§OÂà´«ªº§P§O¨Ì¾Ú?

ÁÂÁÂ

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-2-6 08:42 ½s¿è

¦^´_ 1# lukychien

®æ¦¡¥u¬O§ïÅÜÅã¥Ü¡A¨Ã¤£¯à§ïÅÜÀx¦s®æ¤º®e
¤£À´§A­n§P©w¹ô§Oªº§@¥Î¬°¦ó?
¦pªG­n±N¼Æ­È¶i¤@¨B­pºâ¡A«h¤£¥i¥[¤J¥ô¦ó¤å¦r²Å¸¹
¦pªG­n¨ú±o®æ¦¡ªº¦r¦ê¥i¨Ï¥Î4.0¥¨¶°¨ç¼ÆGET.CELL
¨Ò¦p­n¨úªºAÄ檺®æ¦¡
¿ï¨úB1Àx¦s®æ
´¡¤J/¦WºÙ/©w¸q
x=GET.CELL(7,Sheet1!$A1)
B1¿é¤J¤½¦¡=x
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ª©¥D±z¦n,
¤£¦n·N«ä²{¦b¤~¦^´_¡C
¦]¬°Àɮ׸̲VÂøµÛ¥x¹ô©M¬üª÷¡A»Ý­n±N¼Æ­È¥þ³¡Âà´«¦¨¥x¹ô¡A©Ò¥H¤~·|³o¼Ë°Ý¡C
Excel 2010 ¥i¥H¥Î Excel 4.0ªº¥¨¶°¨ç¼Æ¶Ü?

ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2013-2-7 13:40 ½s¿è

¦^´_ 3# lukychien

§Ú·Q§A¬O­n¿é¤J¼Æ­È«á¦Û°Ê¥[¤J¹ô§O²Å¸¹
¥Î®æ¦¡³]©wÁÙ¬O»Ý­n¤@¤@³]¸m
§Ú«Øij¼W¥[¤@Äæ§@¬°¹ô§O¿ëÃÑ
¨Ò¦p:A1¿é¤J¼Æ­È¡AB1¿é¤J¼Æ¦r1¥Nªí¥x¹ô¡A2¥Nªí¬üª÷
C1¤½¦¡=CHOOSE(B1,DOLLAR(A1,0),USDOLLAR(A1,0))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 4# Hsieh


·PÁª©¥Dªº«ü±Ð»P«Øij¡A
³o¦ü¥G¬O³Ì¤è«K¦n¥Î¥B²Å¦X»Ý¨Dªº¤è¦¡¡C

ÁÂÁ±z
·s¦~§Ö¼Ö

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD