I am getting incorrect answers in adding and subtraction

B

Basher

I am using Excell in Microsoft Office 2007 and am getting incorrect answers
to adding and subtraction it is mostly just a penny out
 
O

Otto Moehrbach

Look at the source of the numbers that are being used in the calculation of
the final number. While you see, say, 6.03 in a cell because the cell is
formatted to 2 decimal places, Excel may see 6.034. The final calculation
is made with 6.034 regardless of how you format that cell. This can easily
built up to a noticeable apparent error. HTH Otto
 

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