Hotmail
Microsoft Excel fails math test
Employee blogger wrote that some multiplication results incorrect
Tech Holiday Gift Guide |
 Holiday tech gadget preview When it comes to gadgets and gear, smaller is better, high fashion is in vogue, and affordability will be king this holiday buying season. That's the message from tech firms. |
 | Tech and gadgets videos |
 TODAY 30 years later, Google search helps reunite pair Nov. 7: Dr. Scott Becker never gave up hope of finding his daughter, and after decades of searching, he found her using a very modern tool. NBC’s Ron Mott reports, then NBC’s Amy Robach sits down with the pair. |
 | Video |
 |
Auto Tech |
A better economy may lure buyers, but these trends could seal the deal. |
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.
"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.
- Discuss Story On Newsvine
-
Rate Story:
View popularLowHigh - Instant Message
MORE FROM TECH AND GADGETS |
 Tech and gadgets Section Front |
| Add Tech and gadgets headlines to your news reader: |
Resource guide