Format issue to linked cells

[JRB9019]

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(C22) 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???

 

[Spiky]

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(C22) 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?

 

[JRB9019]

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

 

[JRB9019]

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

Hi David,


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

Thanks for your help