| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| 2 Nesting questions | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
