| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keeping text format in linked cells | Excel Worksheet Functions | |||
| Obscure issue - recalculating linked pictures! | Excel Discussion (Misc queries) | |||
| HOW DO I KEEP THE SAME FORMAT IN LINKED CELLS ? | Excel Discussion (Misc queries) | |||
| How do I format linked cells? | Excel Discussion (Misc queries) | |||
| Format cells (number) issue | Excel Discussion (Misc queries) | |||
Linear Mode
