According to many verified reports circulating the web today. This is a rather serious problem. It was initially exposed on the Microsoft Public Excel Group where one of their members reported this major bug to Microsoft, although Microsoft has yet to respond.
AppScout pointed out that Excel 2007 can’t multiply certain numbers and you can try it for yourself! For those who rely on Excel for their jobs to calculate large numbersTo try it for yourself, open up Excel 2007 and multiply 850 by 77.1. If you’re unfamiliar with performing calculations in Excel, you’d enter the following into a cell:
=850*77.1
Once you do that, you’ll discover the answer according to Excel 2007 is 100,000. But now get out a calculator or a piece of paper and pencil and do the same calculation and you’ll find that the answer is really 65,535. That’s not the only number Excel has problems with either. According to Neil Rubenking over at App Scout, he found ten thousand of these multiplication calculations that gave the wrong answer
I'm sure Microsoft is researching this and will have a fix for this in the very near future.
 News source: Cybernert News
|
|
