Excel: 2 + 2 = 5

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s