Extend the number of visible decimal places in C2, D2, and Data!F14
You'll see that it isn't exactly 80.60
--
David Biddulph

"JRB9019" wrote in message
...
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???