Excel 2007 has some problems displaying results of some calculations and now, a hotfix is available to correct the problem.
Here's the problem description from the Excel team blog:
http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx
When you perform a calculation in Excel 2007, the following behavior occurs:
| • |
The result of the calculation is a number from 65534.99999999995 to 65535. The calculation is performed correctly. However, the result is incorrectly shown as 100000. |
| • |
The result of the calculation is a number from 65535.99999999995 to 65536. The calculation is performed correctly. However, the result is incorrectly shown as 100001. |
and the hotfix information:
http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx
Note that Microsoft will push automatically this fix via Microsoft Updates but you can download it right now.