Wednesday, September 26, 2007

Excel 2007 Calculation Bug!

Microsoft has confirmed that Excel 2007 incorrectly displays the result of a calculation in 12 specific cases where a result should equal around 65,535. The issue is not in the calculation itself but in the result that is shown in the sheet.

For example, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains “=850*77.1”, and A2 contains “=A1*2”, A2 will return the correct answer of 131,070).

A patch is in the works. More