The $34,465 Excel 2007 calculation bug

Kashflow logo
2

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.

"Hoor...

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk 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.

Share this content

Replies

Please login or register to join the discussion.

avatar
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.

Richard

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