Sep
29

Excel does multiplication incorrectly

Uncategorized

Due to a bug found in Microsoft Excel 2007, certain sets of multiplication is being displayed incorrectly to the user.

I heard this is some old floating point bug.

Excel does multiplication incorrectly

850 * 77.1 supposed to result in 65535. Unfortunately, Excel 2007 displays it as 100,000.

Only specific sets of multiplication is affected. Hope a patch would arrive soon though.

Possibly related:

  1. excel//expert
  2. excel//demonstration
  3. excel//certificate

Tags: , , ,

One comment for “Excel does multiplication incorrectly”

  1. You can always use gnumeric in the mean time – it lacks this feature…

    by Karl Schmidt (Oct 8, 2007 at 1 AM)
 

Leave a Reply

 

Comments may be moderated due to spam. No advertisements are allowed in comments.

You'll require some math knowledge to comment, this is done to stop evil bots from spamming my blog.

Read my comments policy

Want a display picture?