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 raised a lot of controversy, and many users have asked to return it
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 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 Excel's rounding feature itself, not from the argument calculation feature. ' 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. '
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
- Convert PDF files to Word, Excel, HTML, Text
- Detects the third vulnerability in Microsoft Excel
- Excel data entry faster
- Excel again in danger of being attacked?
- Convert XLS files to multiple formats using
- Calculate the subtotal of the list on Excel
- Microsoft acknowledges Excel's error
- Use Excel as a Wiki application
- Add a security error that threatens MS Excel
- We are all 'solving the need' in the wrong way
Don't trust Chrome's Incognito mode Does Chrome browser really consume RAM? Is public Wi-Fi less secure? Nvidia A100 - The most expensive graphics card in the world costs up to 30,000 USD How to create a password that makes even the strongest supercomputer 'fail' Google Maps is about to have a super useful new feature, so you no longer have to worry about getting lost even if you go into an area with no signal Decode the exact meaning of the letter 'i' in the name iPhone Google Photos opens many free AI editing features to users