Software
Hilarious bug in Excel 2007
Sep 25, 2007 5 pm
Try to multiply 850 by 77.1, guess what you’ll get?
Any calculator will show 65535, instead of Excel2007, which is 100000. The bug, seems newly introduced and only Exel 2007 is affected, older versions are free from it.
And there appears to be more of them, for example:
=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=77.1*850
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2
All shows 10000 instead of 65535. The bug has been reported to Microsoft but no fix available yet.
View: Full Story
DigitMemo.com » Microsoft Fixes Excel Calculation Bug said
am October 12 2007 @ 12:34 am
[…] The errors are not in the calculations themselves; the result of the calculations stored in Excel’s memory are correct. But the result that appeared in the Excel spreadsheet is incorrect. Rad more about the Excel Bug. […]