The Budget value is still being coyied to the cell containing the formula.

Then that means CKLOG!$G9 is not "blank".

Try this:

=IF(LEN(CKLOG!$G9)=0,"",BUDGET!$D$19)

Biff

"Denny Crane" wrote in message
...
thanks Biff fkor the insight however it aint working. The Budget value is
still being coyied to the cell containing the formula. Any futher thoughts
on
it would lbe appreciated.

"Biff" wrote:

Hi!

What does ."", in the following mean
=If(isblank(CKLOG!$G9),"",BUDGET!$D$19)

It means that if cell CKLOG!$G9 is blank then the cell that holds this
formula will remain blank. If cell CKLOG!$G9 is not blank then the cell
that
holds this formula will return the value of cell BUDGET!$D$19.

Blank should not be confused with empty.

Biff

"Denny Crane" wrote in message
...
What does ."", in the following mean
=If(isblank(CKLOG!$G9),"",BUDGET!$D$19)

I want -if, CKLOG!$G9 is blank, that BUDGET!$D$19 is not copied to a
third
sheet containing a sell with this formula