SUM errors on excel 2013

Copper Contributor

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.

 

 

Regards,

Haytham