ªð¦^¦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¡^

=ROUND(SUM(®ÉÁ~*TEXT(¥[¯Z®É¼Æ-{0,2},"0;\0;0")*{1.34,0.33}),0)

TOP

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

«D±`·PÁ ­ã´£³¡ªL  ¦^ÂÐ

°w¹ï©Ò­z°ÝÃD
­Y¬O ¥[¯Z®É¼Æ¬° 1.5 ¤p®É®É...¸Ó¤½¦¡(ROUND(SUM(®ÉÁ~*TEXT(¥[¯Z®É¼Æ-{0,2},"0;\0;0")*{1.34,0.33}),0)µª®×¦ü¥G¦³©Ò»~®t
¦p¤U¹Ï©Ò¥Ü



½Ð°Ý¸Ó¦p¦ó­×¥¿°ÝÃD ??
¥t¤½¦¡¤¤  {1.34,0.33}  ¸Ì­±ªº 0.33 ¬O¥Nªí?(¬°¤°»ò¤£¬O 1.67 ?)

1120530.rar (6.89 KB)

TOP

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


    ÁÂÁ¤G¦ì«e½ú
«á¾Ç¾Ç²ß«e½úªº¤è®×,¾Ç²ß­×§ï¤è®×¦p¤U

=ROUND(SUM(B2*TEXT(C6-{0,2},"0.0;\0;0")*{1.34,0.33}),0)
¥Î¦æ°Ê¸Ë¸mÂsÄý½×¾Â¾Ç²ß«Ü¤è«K,ÁÂÁ½׾¸gÀç¹Î¶¤
½Ð¤j®a¤@°_¤W½×¾Â¨Ó¥æ¬y

TOP

¥»©«³Ì«á¥Ñ Andy2483 ©ó 2023-5-31 08:32 ½s¿è

[attach]36473[/attach]

20230531_1.jpg (121.94 KB)

20230531_1.jpg

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

TOP

¦^´_ 4# Andy2483

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

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

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

TOP

¦^´_ 5# Andy2483

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

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

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

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

¦^´_ 8# Andy2483


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

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

1.67- 1.34 = 0.33   ^^

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

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD