Help with this formula please!
 

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

Help with this formula please!
 

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

Help with this formula please!
 

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

Help with this formula please!
 

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

Help with this formula please!
 

A little clarification:

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

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

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

ISBLANK(CKLOG!$G9)

will evaluate to FALSE.

Biff

"Biff" wrote in message
...
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

Help with this formula please!
 

its not blank,try =If(CKLOG!$G9="","",BUDGET!$D$19)
--
paul
remove nospam for email addy!



"Denny Crane" wrote:

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

Help with this formula please!
 

this should have stayed in the original post below
--
paul
remove nospam for email addy!



"Denny Crane" wrote:

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