How can I use the value from a cell in one worksheet in another

[elusiverunner]

Here is my question with detail. In one worksheet I have a value, that is
created by a formula, in a cell. I would like to copy the result of that
formula to a cell in another worksheet. However if the value created by the
formula has not been generated, that is the cell is empty, apart from the
formula, I would like the cell in the other worksheet to be left blank.
The second worksheet cell will have a formula in it to use the value of the
first worksheet.

 

[Dave Peterson]

Check your first post.

Here is my question with detail. In one worksheet I have a value, that is
created by a formula, in a cell. I would like to copy the result of that
formula to a cell in another worksheet. However if the value created by the
formula has not been generated, that is the cell is empty, apart from the
formula, I would like the cell in the other worksheet to be left blank.
The second worksheet cell will have a formula in it to use the value of the
first worksheet.

 

[elusiverunner]

Check your first post.

Dave - thanks very much for your quick reply. I followed your instructions
for both questions I asked. However, in the second question where I need the
results from a formula to be added to a value in a cell in sheet 2 or remain
blank I get zeros. The formula I am putting in is below

=IF('Fuel Consumption 08'!D23="","",'Fuel Consumption 08'!D23+B17)

 

[Dave Peterson]

Doesn't your formula work ok?

If D23 on that 'fuel consuption 08' is an empty string (or completely empty),
then that cell with the formula should look empty (it'll actually evaluate to
"").

Maybe the formula in D23 needs to be changed to make sure it returns "" when it
needs to appear empty.

 

[elusiverunner]

Dave - the only thing in cell D23 is a formula which creates a value in cell
D23. When the formula is removed from D23 meaning there is absolutely
nothing in it then the formula you gave me probuces a blank cell in the Fuel
Consumption 2008(a) worksheet.

 

[Dave Peterson]

Do you want to share the value that's returned in D23?

Do you want to share the formula in D23 and the values of any of the cells that
this formula depends on?

Without those, I don't think anyone will be able to make an informed guess.