Help with this formula please!

D

Denny Crane

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
 
B

Biff

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

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
 
D

Denny Crane

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.
 
B

Biff

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
 
B

Biff

A little clarification:
The Budget value is still being coyied to the cell containing the formula.
Click to expand...
Then that means CKLOG!$G9 is not "blank".
Click to expand...

If there is a formula blank in cell CKLOG!$G9 then:

ISBLANK(CKLOG!$G9)

will evaluate to FALSE.

Biff
 
Top