Excel Can’t Multiply
We all learned how to multiply with pencil and paper, even great big numbers and decimals. But when it comes to something important like a blueprint or a scientific formula we reach for a calculator - or a spreadsheet. That’s much more reliable, right? Well, not if the spreadsheet is Excel 2007. Over the weekend a member of the microsoft.public.excel newsgroup revealed that Excel 2007 thinks that 850*77.1 is 100,000. What’s the correct answer? Anybody? Anybody? Bueller? Anybody? Right, it should be 65,535. Other members verified that the error carries over into some (but not all) calculations based on the incorrect result. Microsoft has been informed of the bug and said:
Microsoft recently learned of the flaw in Microsoft Office Excel 2007 that affects some calculations where the product should equal 65,535. We are currently in the process of developing and testing a fix for the flaw. Microsoft places a high priority on quickly responding to customer feedback and we are committed to finding ways to provide a better software experience.
[VIA]




Leave a Reply