The $34,465 Excel 2007 calculation bug

Share this content

Microsoft has confirmed the existence of a serious calculation flaw in Excel 2007 that can cause an incorrect amount to appear in a cell. Gail Perry and John Stokdyk report.

Molham Serry highlighted the problem on Monday afternoon in the microsoft.public.excel group on Google when he suggested Excel 2007 users try entering the multiplication formula =77.1*850.

Excel displays 100000 instead of the correct answer 65535. Other formulae - but not all that produce the same result - have the same effect. Entering =13107*5, for example, produces the correct result of 65535.

Programmers at Microsoft were informed of the problem on Tuesday and are working on a fix. No date for a correcting update has been projected yet, but it will be made available via Microsoft Update.


Please Login or Register to read the full article

The full article is available to registered members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.


Please login or register to join the discussion.

03rd Oct 2007 17:44

Thin end of the wedge
It does rather beg the question how many more of these 'bugs' will there be? The Microsoft EULA that buyers must agree to before using the software theoretically limits compensation due to faults in the application to the initial outlay on the license, and yet, although nothing has been reported yet, the potential for far greater losses exists.


Thanks (0)
12th Oct 2007 11:26
Thanks (0)