Adding cells with formulas

[Guest]

I am adding 5 cells containing formulas. The sums in these cells are

175.0
10.8
2.5
5.7
1.4

When I add the cells together the total comes up as $195.56 (which is .01 off)

Can someone tell me how to correct this problem?

 

[Frank Kabel]

Hi
You have set the format so that it only DISPLAYS 2 significant digit
but internally Excel may have stored the complete number.
change your formulas to something like
=ROUND(your_formula,2)

 

[Guest]

Thank you very much Frank. That did the trick!

Enjoy the rest of your day

Sue