| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel
Tools Options Calculation and check Precision as displayed.
-- Gary''s Student - gsnu200904 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
