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

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

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

­pºâ¥[¯Z¶O°ÝÃD¦p¤U

¥­¤é¥[¯Z®É¼Æ«e¨â­Ó¤p®É1.34­¿,¶W¹L2¤p®É¤§«áªº®É¼Æ1.67­¿
¤éÁ~¬° 2500...®ÉÁ~¬°312.5

¤µ¥­¤é¥[¯Z®É¼Æ¬° 4 ¤p®É...
¸Õ°Ý¸Ó¤é¤§¥[¯Z¶O¥Î­pºâ¤½¦¡¬°??¡]¥|±Ë¤­¤J¡^

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

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

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

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

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

TOP

¦^´_ 11# Andy2483

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

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

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

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

¦^´_ 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

¦^´_ 4# Andy2483

·PÁ±z  Andy2483 ¦^ÂЬÛÃö°ÝÃD

­Y¬O¥H¦¹¤½¦¡¸Õºâ¶È¥H³æ¤@Àx¦s®æ®É¼Æ¸Õºâ...
ªþ¤W­Y¥H¤@¦¸²Î­p31¤é®É¼Æ¾Ú...
AG36Àx¦s®æ...ROUND(SUM(B2*TEXT(B6:AF6-{0,2},"0.0;\0;0")*{1.34,0.33}),0)
¸Ó¦p¦ó­×¥¿©Ò­z°ÝÃD  ^^


1120718.rar (7.29 KB)

TOP

¦^´_ 8# Andy2483


¤Ó·PÁ±z  Andy2483 ¼ö¤ß¦^ÂÐ

¸g§Aªº¹Ï¤å¸Ô²Ó¸Ñ»¡...¤ñ¸û®e©ö©ú¥Õ

1.67- 1.34 = 0.33   ^^

TOP

¦^´_ 7# cypd
¦^´_ 2# ­ã´£³¡ªL


    ÁÂÁ«e½ú¦^´_
«á¾Ç·Q¤F«Ü¤[¤~·Q³q,«á¾Ç¥H¹Ï¥Ü»¡©ú¦p¤U: ¬Û¦Pµ²ªG¥i¥H¦³¤£¦P·Qªk
¦Ü©ó¨ä¥L¤èªkªº¤½¦¡½Ð ­ã´£³¡ªL«e½ú¦A«ü¾É

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

TOP

¦^´_ 5# Andy2483

·PÁ±z  Andy2483 ªº¦^ÂÐ

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

¥t¤½¦¡¤¤  {1.34,0.33}  ¸Ì­±ªº 0.33 ¤£¸Ñ¬O¥Nªí?(¬°¤°»ò¤£¬O 1.67 ?)

TOP

¦^´_ 4# Andy2483

«D±`·PÁ±z  Andy2483 ªº¦^ÂÐ

¦n¯«©_ªº...  0.0 ¤§®t²§
³ºµM¦³¦p¦¹¤£¦P¼Æ¾Ú

¤w­×¥¿©Ò­z°ÝÃD  ^^

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¨S¦³©Ò¦³Åv¡A¥u¦³¥Í©Rªº¨Ï¥ÎÅv¡C
ªð¦^¦Cªí ¤W¤@¥DÃD