addition total is wrong

[Mary Beth]

my formula for the column total is =round(sum(a4:a15),2) but the answer is
wrong. I am adding 6.30+1.71+1.24 and it gives me a total of 9.27 (should be
9.28). The numbers in column are from a formula not numbers I just inserted
and I think this may be my problem but I don't know how to solve it. The
numbers are a result of a formula to calculate the GST from a number in
another column.

Help please.

 

[Pete_UK]

Yes, your numbers could actually be 6.295, 1.705 and 1.235 (examples
only). You can see this by increasing the numbers of decimal places in
those cells. What you can do is:

=ROUND(your_existing_formula,2)

in those cells, and then you won't get the discrepancy.

Hope this helps.

Pete

 

[Glenn]

Besides that, 6.30 + 1.71 + 1.24 = 9.25

Yes, your numbers could actually be 6.295, 1.705 and 1.235 (examples
only). You can see this by increasing the numbers of decimal places in
those cells. What you can do is:

=ROUND(your_existing_formula,2)

in those cells, and then you won't get the discrepancy.

Hope this helps.

Pete