Excel store and calculate floating point numbers. Sometimes, the result of a formula is an approximation.
| Join the channel Telegram of the AnonyViet 👉 Link 👈 |
Floating point error in Excel
1. For example, see the formulas below. At first glance, everything seems fine.
2. However, if we display 16 decimal places, we can see that a result is a close approximation.
You don’t have to worry about floating point errors. Very rarely do you get this error.
3. Even if your worksheet has a floating point error, that shouldn’t cause problems in most cases. However, if you compare the value in cell C8 with another value, the following problem may occur.
4. Use ROUND function to fix this error.
In addition, you can also view many other excel articles here.
