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

[µo°Ý] ¤£ª¾¦p¦ó¤U¤½¦¡¡H

[µo°Ý] ¤£ª¾¦p¦ó¤U¤½¦¡¡H

¤j®a¦n¡A§Ú¤S¨Ó°Ý°ÝÃD¤F
¦p¦ó¦bªí®æ¤¤A3¡BB3¡K¡KH3µ¥Àx¦s®æ¿é¤J¤½¦¡¡A
Åý¤U¹ÏA1¡BA5¡BA9¤@¿é¤J¼Æ¦r¡A
«K¯à¨Ïªí®æ¥X²{ÂŦ⪺¼Æ¦r¡H

quest.png (6.19 KB)

quest.png

~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

=MID( REPT(" ",7-LEN($C1))&"$"&$C1,COLUMN(),1)

TOP

=LEFT(RIGHT(" $"&$A1,COLUMNS(D7:$K7)))

TOP

«D±`·PÁ¤G¦ì¤j¤jªº¸Ñµª¡AÅý§Ú¤S¸Ñ¨M¤F¤@¥ó¨Æ
¦ý¹ê¦b¤£¸Ñ¡A¬°¤°»ò¬ÛÃþ¦üªºªí®æ¡A

=MID( REPT(" ",7-LEN($C1))&"$"&$C1,COLUMN(),1)´NµLªk¥¿±`¥X²{¡H

=LEFT(RIGHT(" $"&$A1,COLUMNS(D7K7)))¤S¬°¤°»òCOLUMNS(D7K7)¸Ì¬OD7K7¡H

¬Ý¨Ó¬O¹ïCOLUMNS()¨ç¼Æ¤£¤F¸Ñ§a¡H

­ü¡I¦Û¤v¤´»Ý¥[ªo¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2010-10-22 09:40 ½s¿è

¦^´_ 4# ymes


    ¤@ ¦r¦êªø«×¤j©ó7¤~·|¥X¿ù
   ¤G columns(d:k) ·|­pºâD¨ìK¦@¦³¦h¤ÖÄæ¦ì,¥ÎA:H ¤]·|±o¨ì¦P¼Ëªºµª®×,³o¸Ì¤]¥i¥Î 9-COLUMN(A1) ¨ú¥N

TOP

«D±`Á±zªº¸Ñµª¡AÁöµMÁÙ¬O¤£¤Ó¤F¸Ñ¤½¦¡¡A
¦ý¦Ü¤Ö¸Ñ¨M¤F¦Û¨­»Ý¨D¡A·P®¦¡I
~¬Q¤éºØºØ¡AÄ´¦p¬Q¤é¦º~
~¤µ¤éºØºØ¡AÄ´¦p¤µ¤é¥Í~

TOP

¥»©«³Ì«á¥Ñ polo0207 ©ó 2010-10-29 10:24 ½s¿è

¤j®a¦n.. ­è¦n§Ú¤]¦³³o­Ó°ÝÃD, ·Q¦A¶i¤@¨B½Ð±Ð¤j®a~
§Ú©Ò±Ä¥Îªº¤½¦¡¬O =LEFT(RIGHT(" $"&$A1,COLUMNS(D7:$K7)))
1. ¦pªGA1ªº­È¬O¤p¼Æ¥H¤U¨â¦ìªº, §Y 41,200.00.
2. ¦b I ¸ò J ¤À§O§e²{¥X¨¤¸ò¤À, ¤]´N¬Oµ²ªG¥i¥H¥X²{ I3 ªº­È¬° 0, J4 ªº­È¬° 0.
½Ð°Ý¸Ó¦p¦ó­×§ï¤½¦¡?
¥ýÁÂÁ¤j®a¤F~~~

TOP

=LEFT(RIGHT(" $"&$A1*100,COLUMNS(D7:$K7)))

TOP

¦^´_ 8# ANGELA


    ¤j¤j¤Ó¼F®`, ÁŵM¶}®Ô! ÁÂÁÂ! ÁÂÁÂ! ÁÂÁÂ!

TOP

¦^´_ 9# polo0207

hi ¦U¦ì¤j¤j¦n,

¦pªG­n°µ¨ìªþÀɬõ¦â¦rªº³¡¤À¦Û°ÊÂà´«¦¨³ü¶L叁¸v¥î?
§Ú¦³§ïÀx¦s®æ®æ¦¡¬°¯S®í, ¤£¹L¥X¤£¨Ó~~
¦A¦¸³Â·Ð¤j®a¤F, ¥ýÁÂÁ¦U¦ì¤j¤j¤F~~

TOP

        ÀR«ä¦Û¦b : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD