News Archive - September 2007
Excel can't multiply
Tuesday 25th September 2007
Category: News
A somewhat serious bug in Excel has been found recently - specifically, that Excel 2007 will multiply incorrectly in some cases. Some of the examples given are:
- =850x77.1
- =5.1*12850
- =10.2*6425
- =20.4*3212.5
- =40.8*1606.25
- =77.1*850
Those with a calculator handy, or far more proficient in mental arithmetic than I, will be able to tell us that the result should be 65,535. Excel 2007, on the other hand, decides that 100,000 is close enough.