Skip navigation
advertisement
sponsored by 

Microsoft Excel fails math test

Employee blogger wrote that some multiplication results incorrect

  Tech Holiday Gift Guide  
  More
Holiday Retail
10 best Xbox 360 games of 2009
With all the incredible games that have been released for Microsoft’s Xbox 360 this year, trying to write a “Best of 2009” list feels an awful lot like trying to stick 20 pounds of sand into a 2-pound sack.

  Real Women’s Guide to Technology

An MSN special that focuses on consumer technologies that can benefit women.

Tech and gadgets videos
Texting may be bad for you
Dec. 17: New studies find that texting is not only bad for your eyes, but can cause chronic pain in the neck, shoulders and fingers. Dr. Nancy Snyderman talks with opthamalogist Dr. Roger Steinert and spine surgeon Dr. Charles Rosen.

Video
Tech Watch
The latest in technology and entertainment news.
  Auto Tech

A better economy may lure buyers, but these trends could seal the deal.

Go to Auto Tech

updated 1:29 p.m. ET Sept. 28, 2007

SEATTLE - Microsoft Corp.'s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.

In a blog post, Microsoft employee David Gainer said that when computer users tried to get Excel 2007 to multiply some pairs of numbers and the result was 65,535, Excel would incorrectly display 100,000 as the answer.

Gainer said Excel makes mistakes multiplying 77.1 by 850, 10.2 by 6,425 and 20.4 by 3,212.5, but the program appears to be able to handle 16,383.75 times 4.

Story continues below ↓
advertisement | your ad here

"Further testing showed a similar phenomenon with 65,536 as well," Gainer wrote Tuesday.

He said Excel was actually performing the calculations correctly, but when it comes time to show the answer on the screen, it messes up.

Gainer said the bug is limited to six numbers from 65,534.99999999995 to 65,535, and six numbers from 65,535.99999999995 to 65,536, and that Microsoft is working hard to fix the problem.

© 2009 The Associated Press. All rights reserved. This material may not be published, broadcast, rewritten or redistributed.

Resource guide