SUM errors on excel 2013

Occasional Visitor

I just discovered errors using the SUM command.  It seems that when I multiply two cells and the answers I add to other cells it gives me a one cent or two cent error if I have multiple numbers.  I attached a powerpoint slide to show you. 

1 Reply

Hi Alex,


In fact, this is not an error!

But there are hidden decimal places that Excel take them into account!

Decimal Places Trick.png


Please check out my answer to this question.