Excel 2007 این ضرب را چگونه انجام میدهد ؟
لطفا چک کنید ببینین اکسل حاصل این ضرب را چند نمایش میده ؟
850*77.1
آیا
100,000
هست یا 65,535.
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, but hasn't yet formulated a response.
UPDATE: Microsoft recognizes the problem and assures us that Excel Will Learn to Multiply.