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.