News Archive - September 2007 - News Post
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.
Comments
Submit a comment
We are currently experiencing difficulties with the database - please bear with us, it should be fixed soon! Until it is fixed, new comments cannot be submitted, although existing comments can still be read.