Total calculation out by .2
Hi RagDyerR,
And check "PrecisionAsDisplayed", but this really hinders *exact*
calculations in your WB
It doesn't. The option only affects cells which are explicitly formatted. So
if a cell doesn't show many digits because the column is too narrow, it will
still be calculated with maximum precision.
Certainly in financial spreadsheets I find Precision as displayed a very
useful option.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"RagDyeR" wrote in message
...
I would guess that your problem is rounding.
Your formula is probably producing numbers that are in excess of 2 decimal
places, but since you've set your format to two places, XL is displaying
*two* places, but XL is calculating *all* the decimals.
When dealing with money, it's always a good idea to wrap your formulas in
a
rounding function.
=ROUND(A1*B1,2)
This returns numbers that match exactly what you see displayed.
You could also change the way your WB displays it's numbers by :
Tools Options Calculation tab,
And check "PrecisionAsDisplayed", but this really hinders *exact*
calculations in your WB.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"S Findlay" wrote in message
...
Hi, having trouble have one column of figures produced by formula when I
total up at the bottom of the sheet they are out by .02 do not know how
to
solve this problem, I have been into format cells to 2 decimal places but
still differs.
|