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.

elusiverunner wrote:

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" wrote:

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 wrote:

"Dave Peterson" wrote:

Check your first post.

--

Dave Peterson

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


--

Dave Peterson