Calc error

M

Michel Finschi

Got a tricky error in my Excel (2004 for Mac, Version 11.2 (050714)

The difference between the two figures:

a1 6833.40
a2 6828.66

Important note: both figures were manually entered exactly as above, no
further (hidden) digits.


Is correctly calculated by Excel as 4.74 in cell a3. So far, so good.

However, when increasing the number of digits for a3 to the max of 30, then
Excel returns the result:

4.739999999999780000000000000000,

Why is this?

Thanks, Michel
 

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

Similar Threads

1p out again! 5
Working with dates 3
Concatenation help 8
Complicated IRR problem 2
conditional formatte date in a1 calculate the date in A2 3
Rounding error is conditional on brackets 2
=If - how to tell it to calc certain %'s only 2
Apply Conditional Formatting to other rows 6

Top