Numbers is dropping a penny multiple times when adding a column or one row to another row in the column. Even when multiplying a number time the number of rows in the column.
[Re-Titled by Moderator]
Mac mini, macOS 12.7
If you want to round the actual value of the cell, not just the display, then use the ROUND() function:
For example, assume the cell D2 contains the underlying value 593.095
D2 is set to display to 2 decimal places, so displays as 593.10, even though the underlying value is different.
Set cell D3 to:
=D2 x 2
you get 1186.19 (twice the underlying value)
Set D3 to:
=ROUND(D2,2) x 2
you get 1186.20 because the cell D2 is rounded to two decimal places before it's multiplied.
If you want to round the actual value of the cell, not just the display, then use the ROUND() function:
For example, assume the cell D2 contains the underlying value 593.095
D2 is set to display to 2 decimal places, so displays as 593.10, even though the underlying value is different.
Set cell D3 to:
=D2 x 2
you get 1186.19 (twice the underlying value)
Set D3 to:
=ROUND(D2,2) x 2
you get 1186.20 because the cell D2 is rounded to two decimal places before it's multiplied.
Would need to see the formula used for the calculation. Each field displays a rounded number based on the format, but the underlying value may be different.
For example the cell showing $593.10 may be for the value $593.096 and when added together would be $1186.192, which would show in the formatted cell as $1186.19.
You are correct. I did not realize that $593.10 was actually $593.095….!
Thank you for setting me straight.
Glad I could help, thanks for the update!
Numbers Addition Errors with Dropped Penny
