Adding cells with formulas

S

Sue

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?
 
F

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)
 
Top