addition total is wrong

  • Thread starter Thread starter Mary Beth
  • Start date Start date
M

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.
 
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
 
Besides that, 6.30 + 1.71 + 1.24 = 9.25

Pete_UK said:
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
Click to expand...
 
Back
Top