Can 2 +2 be 5?
Yes, at least if you look at this example in Excel:
Of course, Excel doesn’t make mistakes like that, so there must be an explanation. Let’s try to increase the number of decimals:
As it turns out, the real calculation wasn’t 2 + 2; it just looked like that. It was actually 2,4 + 2,4 = 4,8, but when you decrease the number of shown decimals to none, Excel displays the nearest integer in the cell, and it looks like 2 + 2 = 5. The actual number behind doesn’t change.
More Excel oddities:
- Convert numbers to Thai text with the BAHTTEXT function
- Use Excel to convert Arabic Numbers to Roman and back
Are you using a non-English version of Excel? Click here for translations of the 100 most common functions.