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.