excel
 

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,
--
Kathy

excel
 

Check out this link...

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

Jim Thomlinson


"Kathy" wrote:

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,
--
Kathy

excel
 

Tools Options Calculation and check Precision as displayed.
--
Gary''s Student - gsnu200904