"Spiky" wrote:

On Aug 22, 3:03 pm, JRB9019 wrote:
Hi,
All the following cells are formatted at standard Numeric, 2 decimal places.
I have 2 cellsC2 and D2 and type in the value of 80.60.
I use =SUM(C2:D2) in Cell E2 - the result in Cell E2 is 161.20 (of course!!).

OK, now I reference a field in another worksheet with the same values so,
C2 & D2 now read =Data!F14 (where Data!F14 has the value of 80.60).
c2 & d2 DISPLAY 80.60. However, Cell E2 now displays 161.19.

Can anyone help???

I'm betting that Data!F14 doesn't actually equal exactly 80.60, is it
a formula?

Yes, F14 is a Formula. Thanks for the "Nudge", I've now used ROUND in the
Formula and the problem has gone away!!!

Thanks for your help