Excel 2007 also calculates the wrong results

Microsoft yesterday (September 26) officially acknowledged the latest version of Excel 2007 spreadsheet application with floating-point value errors. This error has sparked a lot of controversy, and many users who have asked for a refund have bought the Excel 2007 license.

Software experts say the floating point value error will sometimes cause Excel to be mistaken and round the wrong value. However, malfunctions only occur with certain values. Usually an error occurs when the value of the calculation function reaches the value of 65,536 or 65,535. In some cases Excel will round those values ​​to 100,000.

In BetaNews' test, the value of 65,535 did not cause errors. Similar traits also occur with numbers that have a long sequence of numbers behind the decimal point. For example, the formula 88.3 * 742,18573 produces the correct rounding result of 65,535 without errors.

Expert David Gainer of Microsoft said the error arises from the rounding feature of Excel rather than from the function of calculating arguments. ' For example, calculation = 850 * 77.1 will produce false results. But if you continue to use that result to calculate, the results are still correct. Usually an error will occur in the argument range 65534,99999999995 and 65535, between 65534.99999999995 and 65535. '

Excel 2007 also calculates the wrong results Picture 1
The formula 850 * 77.1 should be = 65535 but
Excel 2007 again rounds to 100000.

Microsoft is trying to find a solution to overcome the problem.

Hoang Dung