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

[µo°Ý] ­pºâ¥[¯Z¶O°ÝÃD

¦^´_ 10# cypd


    ÁÂÁ«e½ú¦A¦^´_
«á¾Ç¤½¦¡«Ü®z,½Ð«e½ú­Ì«ü¾É¤½¦¡¤è®×ªº¸Ñªk
«á¾ÇÂǦ¹©«½m²ßVBA,¾Ç²ß¤è®×¦p¤U,½Ð«e½ú°Ñ¦Ò

©T©w¤éÁ~¤è®×°õ¦æµ²ªG:


¤£¦P¤éÁ~¤è®×°õ¦æµ²ªG:



1120718_20230718_1.zip (33.25 KB)
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

1) ¥[Á`«á¦A¶i¦ì
=ROUND(SUM(MMULT({1,1},$B$2*TEXT(B6:AF6-{0;2},"0.0;\0;0")*{1.34;0.33})),0)

2) ¶i¦ì«á¦A¥[Á`
=SUM(ROUND(MMULT({1,1},$B$2*TEXT(B6:AF6-{0;2},"0.0;\0;0")*{1.34;0.33}),0))

TOP

¦^´_ 11# Andy2483

¦A«×·PÁ±z  Andy2483 ¼ö¤ßªº¦^ÂÐ

ÀÉ®×¥[¤W¹Ï¤å¸Ñ»¡§ó¥[¤F¸Ñ¨ä¹B§@ÃöÁp

¨Ãªþ¤W¨âºØ¤£¦P¤è®×°õ¦æ¸Ñªkµ²ªG¨Ñ°Ñ...Àò¯q¨}¦h(Æg°Õ  ^^)

TOP

¦^´_ 12# ­ã´£³¡ªL

«D±`·PÁ  ª©¥D  ­ã´£³¡ªL  ¼ö¤ß´£¨Ñ¨âºØ¤è®×

1.¥[Á`«á¦A¶i¦ì...=ROUND(SUM

2.¶i¦ì«á¦A¥[Á`..=SUM(ROUND

¸g¸Õºâ´ú¸Õ¤w±Ä 2.¶i¦ì«á¦A¥[Á`¤§¤è®×..=SUM(ROUND...

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD