It is truly incredible but even in this day and age, Microsoft's table calculation methods sometimes churn out huge miscalculations. Can one trust the results of his/her own calculations?

The program commits a faux pas while calculating a particular number range. First, rectify the error: go to www. microsoft.in and enter 'kb943075' in the search. A Knowledge Base Article
is displayed. Here, you will see the download link for Excel 2007Hotfix package dated 9th October 2007. For installation, double click on the file and accept the license conditions. BACKGROUND: Excel 2007 is weak in certain number ranges; here, the calculation program gives an output of completely wrong values. This includes results between 65534.99999999995 and 65535 as well as between 65535.99999999995 and 65536. Instead of these numbers, the table calculation shows 100000 or 100001. The reason for this: systematic inaccuracies while displaying binary numbers.

Name: 8949.jpg Views: 387 Size: 27.6 KB

You can easily try this out by entering '=154.2*425' in a cell. If you use this result in further calculations, you will still possibly get a correct result, since Excel makes a mistake only in displaying the value; the correct number is however retained in the background. However, if you want to use the 'ROUND' function for the result cell, Excel carries out the calculation with the incorrect value 100000 instead of 65535.