addition total is wrong

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.
 
P

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
 
G

Glenn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top