¦³¿ìªk¨ÌÀx¦s®æ¤º®e§ïÅܸӦCªº¦C°ª¶Ü¡H
- ©«¤l
- 14
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 23
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- OFFICE 2003
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-11-11
- ³Ì«áµn¿ý
- 2013-3-19
|
¦³¿ìªk¨ÌÀx¦s®æ¤º®e§ïÅܸӦCªº¦C°ª¶Ü¡H
½Ð°Ý¦U¦ì¥ý¶i¡A¦pªG§Ú¦b¤@¥÷¤u§@ªí¤¤¡A¦C°ª¯à§_¨Ì¬YÓÀx¦s®æªº¦r¤¸¦Ó§ïÅܸӦCªº¦C°ª©O¡H
¨Ò¦p¡G
¡@¡@ì®Æ¡@¡@¡@¡@¼t°Ó¡@¡@¡@¡@¨Ï¥Î¤u¦a¡@¡@¡@¼Æ¶q¡@¡@¡@¡@³Æµù
¡@¡@¤ôªd¡@¡@¡@¡@¢ê¢ê¢ê¡@¡@¡@¢°¢±¢²¡@¡@¡@¡@¢±¢·
¡@¡@¬â¡@¡@¡@¡@¡@¢é¢é¢é¡@¡@¡@¢³¢´¢µ¡@¡@¡@¡@¢°¢¯¢¯
¡@¡@¥~¿j¡@¡@¡@¡@¢ë¢ë¢ë¡@¡@¡@¢¶¢·¢¸¡@¡@¡@¡@¢´¢¯
¦]§Ú¤u§@ªí¸Ìªº¸ê®Æ¬O¥Hvlookup±q¨ä¥L¤u§@ªí§ì¨Óªº¡A¦Ó³o¥÷¸ê®Æ¬On¦C¦L¥X¨Ó¶ñ¼gªº¡C¦Ó¹³³o¼Ëªº¤u§@ªí¡A¦]¬°¡y¥~¿j¡z³oÀx¦s®æªº³Æµù¤â¼g³¡¥÷·|¯S§O¦h¡A©Ò¥H·Q½Ð°Ý¡A¦³¨S¦³¿ìªkÅý¡y¥~¿j¡z¨º¦Cªº¦C°ª¦b¸ê®Æ§ì¤J¡y¥~¿j¡z«á¡A·|¦Û°Ê§ïÅܦ¨§Ú§Æ±æªº¦C°ª©O¡H
³Â·Ð¦U¦ì¥ý¶i«ü±Ð¡A¸U¤À·PÁ¡I |
|
©é©R¾Ç,©é©R«õª¾ÃÑ
|
|
|
|
|
¡@¼ÊºÙ: ÀH·ÄÆ¿ºªº¦Ð¤ò ¡@ÀY»Î: [±s¥Î]¼ç¤ô¸¥
°ª¤¤¥Í
- ©«¤l
- 852
- ¥DÃD
- 79
- ºëµØ
- 0
- ¿n¤À
- 918
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7 , XP
- ³nÅ骩¥»
- Office 2007, Office 2003,Office 2010,YoZo Office
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¦t©z
- µù¥U®É¶¡
- 2011-4-8
- ³Ì«áµn¿ý
- 2024-2-21
|
½Ð°Ý¦U¦ì¥ý¶i¡A¦pªG§Ú¦b¤@¥÷¤u§@ªí¤¤¡A¦C°ª¯à§_¨Ì¬YÓÀx¦s®æªº¦r¤¸¦Ó§ïÅܸӦCªº¦C°ª©O¡H
¨Ò¦p¡G
¡@¡@ ...
smmriyonk µoªí©ó 2013-3-12 23:59
°²³] ·Qn¤Á´«ªº¦r¼Æ¬°10¡A³æ¦C°ª«×¬° 16.5¡AÀx¦s®æ¦r¼Æ¬° X(X¤j©ó10)¡AAÄæ¦ì
kks = (cells(1,"A")/10)
uew = instr(1,kks,".")
qg = (mid(uew,1,uew-1)*16.5 '¦¹¦æ ¥i§PÂ_¦r¼ÆY¬° 10ªº¿¼Æ¡A¥B ©¿²¤¾l¼Æ |
|
¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~
¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk
¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# smmriyonk
¦³¸Õ¹L±N³Æµù¨ºÄæÀx¦s®æ®æ¦¡¤Ä¿ï¦Û°Ê´«¦C¶Ü? |
|
|
|
|
|
|
- ©«¤l
- 11
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 20
- ÂI¦W
- 0
- §@·~¨t²Î
- Xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2013-3-21
- ³Ì«áµn¿ý
- 2023-8-11
|
¥u¦³³æ¤@¦Cªº¸Ü,
¥i¥HÂI¿ï¸Ó¦C,
µM«á¿ï¾Ü"®æ¦¡"-->"¦C"-->"¦Û°Ê½Õ¾ã"
¸Ó¦C´N·|Åܦ¨¾A·íªº¦C°ª!
§A¬O°Ý³oÓ¶Ü? |
|
|
|
|
|
|