How to sum rounded numbers in Excel.

Twitter user @WickedGoal asked me yesterday "@howtobookkeep -- My biggest problem with Excel is how it sometimes has 0.01 discrepancy in multiplications. Very annoying. :-"

I've had this problem before but had always corrected it manually since it was always used in one off sums. However, if you need to change numbers afterwards it can be a bit of a headache working it all out again! The problem is, when you format numbers in Excel, you can choose how many decimal places to show. However if you calculate any formulas it will use the ordinal number with all decimal places instead of the rounded version.

For example:

A1 = 5.15
A2 = 6.15
A3 = 7.15
A4 = Formula

The formula would be:
"=SUM(ROUND(A1:A3,2))"

The final step -- don't skip this, it's important!

Once you've typed that in, press CTRL+SHIFT+Enter -- this saves the formula, if you just press Enter you will get an error message!

This will make it look like this: {=SUM(ROUND(A1:A3,2))}

But you can't just put the brackets in, you have to use CTRL+Shift+Enter

- See more at: http:--www.howtobookkeep.com-blog-decimal-discrepancies-when-using-rounded-numbers-in-excel-#sthash.uRou0HkL.dpuf

свернуть