excel

[Kathy]

I have a problem with column totals where the cells I am totally are created
by a formula that I have set the answer at 2 decimal points, the totals are
out 1 cent and I can't figure out how to make it add exactly what is showing
in the cell....can anyone help

thanks,

 

[Jim Thomlinson]

Check out this link...

http://www.mcgimpsey.com/excel/pennyoff.html

 

[Gary''s Student]

Tools > Options > Calculation and check Precision as displayed.