View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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