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

[µo°Ý] ­pºâ­È¥|±Ë¤­¤J

[µo°Ý] ­pºâ­È¥|±Ë¤­¤J

·Q½Ð±Ð¤@¤U¦U¦ì¤j¤j¡A
¦pªG§Ú·Q§âSheet1ªº(F*G/1000)ªºµ²ªG©ñ¦bH
½d³ò³£¬O¾ã¦æ
¥Ø«e§Úªº¼gªk¬O³o¼Ë
Worksheets("Sheet1").Range("H2:H" & [F65536].End(xlUp).Row) = [F2:F65536*G2:G65536/1000]

§Ú·Q­n¨ú¥|±Ë¤­¤J¨ì¤p¼ÆÂI«á²Ä¤G¦ì
¤p§Ìª¾¹D¥|±Ë¤­¤J¼gªk¬O
=round(¼Æ­È,«O¯d¦ì¼Æ)
¤]´N¬O=Round(H2:H65536,2)
¦ý¤p§Ì¤£ª¾¸Ó¦p¦ó¦w´¡¤W­z¤½¦¡
·Q½Ð±Ð¤@¤U¤j¤j

Range([H2], [F65536].End(xlUp).Offset(, 2)) = [round(F2:F65536*G2:G65536/1000,2)*row(A2:A65536)^0]
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

·PÁÂHsieh¤j¤j
¤p§Ì¨ü±Ð¤F¡A
¤p§Ì§¹¥þ¨S·Q¨ì°t¦XAªº¹s¦¸¤è³oºØ¤èªk
·PÁÂ

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«z!!¯uªº±q¨S³o¼Ë·Q¹L­C

­ì¥»¨Ó·Q»¡­n¤£­n¦A©w¸q¤@­Ó­È¡A
µM«á­Èªº¤½¦¡¦Aµ¹¥¦°µ¥|±Ë¤­¤J¡A
µ²ªG¨ÌµM¤£¦æ¡A´N¥dÃö¤F

·Q¤£¨ìÁÙ¦³³o¼Ëªº¥Îªk
[c8:g8] = [SMALL(c7:g7,column(a1:e5))*column(a1:e1)^0]
vba¤¤¦h­ÓÀx¦s®æ¦P®É¼g¤J¤@­Ó¤½¦¡®É«á­±*COLUMN(A1:E1)^0´N¥²¶·ªº¡A¤~¤£­P¦¨¬°²Ä¤@­Ó­È¡C

¦A¦¸¨£ÃѨ쪩¥Dªº¼F®`

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD