How can 2+2 be 5?
According to Excel it’s possible!
Of course, Excel doesn’t make mistakes like that, so it’s down to how you use the application. If you’re not careful, you might deliver a report to your boss one day which concludes that 2+2 equals 5!
Let’s increase the number of decimals:
Now it makes sense; 2,49 + 2,49 = 4,98
Excel does calculate correctly even if you use the Decrease Decimals feature. It just doesn’t always look that way…
Author: Audun Danielsen