Excel thinks 7 + 7 + 3 = 18...what gives?

[StingMe]

So Excel will round the number for display but all available decimal places are used in any calculations...can't believe I've never paid much attention to this.

Here's a workaround...by checking "Precision as Displayed" in the Calculation Preferences calculations will be based on only what is displayed. This is a workbook-level preference setting:



Doing this leads to 7 + 7 + 3 = 17 so I'm happy for now