Joel has an interesting post about a current Excel 2007 bug.

Here is the short explanation given by Joel. What is `3 x 1/3`

, if I ask you? You would rattle off “`1`

, of course”. What if I tell you - “note down `1/3`

in decimal on paper, then multiply by `3`

” ? Now since there is no finite decimal representation of `1/3`

on paper(you will keep writing `0.333333333333`

…. forever), you will stop after a few decimal places. And when you multiply by `3`

, you get `0.99999`

, which is not the same precise number as `1`

.

The same problem arises in Excel because of the way Excel works with numbers. Check the article for complete Excel specific explanation.

comments powered by Disqus