Excel multiplication bug unearthed

If you have 850 of something, you might want to hold off multiplying that number by 77.1, at least if you're using Microsoft Office 2007's version of Excel. A bug recently found in the spreadsheet will return an incorrect answer.

Excel spreadsheet bug screen shotThe bug appears to be only in the 2007 version. Discussion has been ongoing over the extent and nature of this problem.

When the formula '=850*77.1' is entered in an Excel cell, the wrong answer 100,000 is returned. The correct answer is 65,535.

The bug was first reported in the Microsoft.public.excel newsgroup. According to participants of that group, when those two numbers are entered as a formula, or entered as part of the =SUMPRODUCT function, the incorrect number appears.

Update (9/26/07): Microsoft has issued a statement that confimed that Microsoft Office Excel 2007 has a flaw "that affects some calculations where the product should equal 65,535." It goes on to say that the company is "currently in the process of developing and testing a fix for the flaw."

About the Author

Joab Jackson is the senior technology editor for Government Computer News.

Featured

  • Records management: Look beyond the NARA mandates

    Pandemic tests electronic records management

    Between the rush enable more virtual collaboration, stalled digitization of archived records and managing records that reside in datasets, records management executives are sorting through new challenges.

  • boy learning at home (Travelpixs/Shutterstock.com)

    Tucson’s community wireless bridges the digital divide

    The city built cell sites at government-owned facilities such as fire departments and libraries that were already connected to Tucson’s existing fiber backbone.

Stay Connected