Joelonsoftware

An Interesting Excel Bug

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.