Skip to main content.

6. To err is human... to blame your computer for your mistakes is even more human, it is downright natural. - Murphy's Laws of Computing

Navigation

• Main
  • Front Page
  • Archive
• Articles
  • All Articles
  • Reviews
  • Guides
  • Other Articles
  • Category Search
• Us
  • About Us
  • Contact Us

Atom 1.0 Feed
Other Feeds
What Are Feeds?

Valid XHTML 1.0
Valid CSS

All content on this website is copyright
© 2005 - 2008
free-bees.co.uk
unless otherwise specified

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

Name:
E-mail Address:
Subject (required):
Comment (required):
Anti-spam question:	What is seven minus five?
	Make comment public
	This comment is spam

Please note that your e-mail address will not be given out to any other parties, or published in any way. The sole use of your e-mail address will be to reply to your comment.

Please also note that any comments that are abusive or otherwise offensive will be deleted. Even if you fervently disagree with any points made, comments should remain polite and respectful of others' points of view.