ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can rounded numbers be summed without rounding errors? (https://www.excelbanter.com/excel-discussion-misc-queries/70198-can-rounded-numbers-summed-without-rounding-errors.html)

chelseab

Can rounded numbers be summed without rounding errors?
 
Can rounded numbers be summed without creating additional rounding errors?

[email protected]

Can rounded numbers be summed without rounding errors?
 
"chelseab" wrote:
Can rounded numbers be summed without creating
additional rounding errors?


No. That is why the IRS states (1040 instructions): "If you
have to add two or more amounts to figure the amount to
enter on a line, include cents when adding the amounts and
round off only the total".

Consider values $1.49 and $2.49. If you add then round, you
get $4 (1.49+2.49 = 3.98). If you round first, you get $3
(1+2 = 3).



All times are GMT +1. The time now is 03:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com