Format issue to linked cells

  • Thread starter Thread starter JRB9019
  • Start date Start date
J

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(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???
 
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???
Click to expand...

I'm betting that Data!F14 doesn't actually equal exactly 80.60, is it
a formula?
 
Spiky said:
I'm betting that Data!F14 doesn't actually equal exactly 80.60, is it
a formula?
Click to expand...
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
 
David Biddulph said:
Extend the number of visible decimal places in C2, D2, and Data!F14
You'll see that it isn't exactly 80.60
Click to expand...

Hi David,


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

Thanks for your help
 
Back
Top