calculaton and accuracy issue

[terry]

I am having a problem with the calculation and accuracy of
a worksheet. The problem is:
three columns
1st column gross entered manually
2nd column entered by a formula to calculate 15% of gross
3rd column entered by a formula to substract 15% of gross

the third column is off by a few cents on most of the line
entries. the grand total columns are also off by a few
cents but do not manually add up to the equal the
worksheet. still off by a few cents.

i have checksd the currency setting, decimal setting and
how formuls were setup.

any suggestions? thanks, terry

 

[Niek Otten]

Tools>Options>Calculation, check Precision as displayed. Look in Help to be
aware of possible effects.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Frank Kabel]

Hi
though you may have changed the display of the cells to two decimals
Excel internally calculates with full precision (e.g. 15 significant
digits). So you may use ROUND in your formulas. Also see:
http://www.cpearson.com/excel/rounding.htm