addition total is wrong
 

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.

addition total is wrong
 

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

On Jan 29, 5:11*pm, Mary Beth
wrote:
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.

addition total is wrong
 

Besides that, 6.30 + 1.71 + 1.24 = 9.25

Pete_UK wrote:
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

On Jan 29, 5:11 pm, Mary Beth
wrote:
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.