Format issue to linked cells
 

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???

Format issue to linked cells
 

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?

Format issue to linked cells
 

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???

Format issue to linked cells
 

"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

Format issue to linked cells
 

"David Biddulph" wrote:

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


Hi David,


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

Thanks for your help