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

Micah Soto

Update 24 May 2019

You should read it

May be interested

Methods to protect E-mail from being looked at
e-mail is an unreliable communication tool, but it's not entirely private. when e-mail is transferred between sender and receiver via the internet, it can be 'snooped' and 'compared'.
Create links (Link) in MS Word
ms word: today's lesson quantrimang.com will guide you how to mark text lines (bookmark) and instructions for creating links to an existing file, web page, email or link in the same file, ...
Count the number of characters in the paragraph
this is a quick, accurate way to count characters in word text.
MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets
the previous article tipsmake.com has guided you to some basic formatting for a small data area, but if you need to format a large area or the default format for a new excel 2003 file, follow these instructions.
Set password protection file not open and save content edit
ms word: you want to protect your documents that no one can read; or just read without editing, quantrimang.com will guide you how to set a password to protect the file as follows:
Set password to protect text file content but still be readable (Office 2003)
ms word: you want to share the text file content for others to read, but you don't want the data in your file to be edited; quantrimang.com will show you how to do the following:

Excel 2007 also calculates the wrong results

You should read it

May be interested

Office information