Total calculation out by .2
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.
|