Apple Vision Pro is now available in the U.S.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

math error when adding currency in numbers app

I have a blank generic sheet in numbers. I have a column which contains the total charge for a rate times a usage (i.e. 2083 usage times $0.00177 rate = $3.69 in total charge column) with a couple onesy twosy charges in there as well. When I use a formula to sum the total charge column, it is off by $.01. I have confirmed this by manually totaling the column with a calculator. Numbers calculates the total of the column as: $44.33 and it should be $44.34.


Here are the actual numbers:



The functions in numbers are:

ColumnD Func (B x C) for each cell in ColumnC

ColumnE Total Func (Sum(D11:D19) (which includes the $.01 at the top thru the $6.86 at the bottom)


I also tried using this for ColumnE Total Func (D11+D12....etc... all the way down to D19) and got the same result.


When I add the numbers up on a calculator, I get $44.34.


Not sure where the math error is being introduced and $.01 isn't a huge deal, but it's still an error.




Posted on Aug 17, 2022 2:08 PM

Reply
Question marked as Best reply

Posted on Aug 17, 2022 4:35 PM

The values in column D are displayed with only two decimal places but the actual values in the cells may have many more decimal places than that (and yours definitely do). Setting the cell format to show only 2 decimal places does not actually round the value in the cell to 2 decimal places. If you want the vaue in the cell to be exactly as you see it, you must use ROUND.


=ROUND(BXC, 2)


If you do that, the numbers will add up as you expect.

Similar questions

3 replies
Question marked as Best reply

Aug 17, 2022 4:35 PM in response to DarthFlyeater

The values in column D are displayed with only two decimal places but the actual values in the cells may have many more decimal places than that (and yours definitely do). Setting the cell format to show only 2 decimal places does not actually round the value in the cell to 2 decimal places. If you want the vaue in the cell to be exactly as you see it, you must use ROUND.


=ROUND(BXC, 2)


If you do that, the numbers will add up as you expect.

Aug 17, 2022 2:33 PM in response to DarthFlyeater

I think that you are being tricked by the question about round first then add or add, then round


what I mean is that you used your calculator to add values that are the product a a decimal value with two decimal places and another with 6 decimal places.


2083.00*0.00177 +

2083.00*0.00458 +

2083.00*0.0012484 +

.

.

.


is different than:

round(2083.00*0.00177, 2) +

round(2083.00*0.00458, 2) +

round(2083.00*0.0012484, 2) +

.

.

.



math error when adding currency in numbers app

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.