| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if the result of a formula is null
in cell A1, I have a formula:
=IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time Line'!a"&ROW())) How would I check for this condition in code? I'd tried using: if len(Range("A1") = 0 then... but it seems to evaluate the actual cell contents, not the result of the formula in the cell (consequently, the condition always checks TRUE) thanks in advance, mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if the result of a formula is null
if len(Range("A1").Value)=0 then
-- Gary''s Student "mark kubicki" wrote: in cell A1, I have a formula: =IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time Line'!a"&ROW())) How would I check for this condition in code? I'd tried using: if len(Range("A1") = 0 then... but it seems to evaluate the actual cell contents, not the result of the formula in the cell (consequently, the condition always checks TRUE) thanks in advance, mark |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if the result of a formula is null
actually.. that's what I meant to type in this post (.value...)
unless i'm missing something else...it checks the cells contents and notes the formula in the cell as having length; versus the length of the result of the formula -mark "Gary''s Student" wrote in message ... if len(Range("A1").Value)=0 then -- Gary''s Student "mark kubicki" wrote: in cell A1, I have a formula: =IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time Line'!a"&ROW())) How would I check for this condition in code? I'd tried using: if len(Range("A1") = 0 then... but it seems to evaluate the actual cell contents, not the result of the formula in the cell (consequently, the condition always checks TRUE) thanks in advance, mark |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if the result of a formula is null
nevermind... got it, thanks
"mark kubicki" wrote in message ... actually.. that's what I meant to type in this post (.value...) unless i'm missing something else...it checks the cells contents and notes the formula in the cell as having length; versus the length of the result of the formula -mark "Gary''s Student" wrote in message ... if len(Range("A1").Value)=0 then -- Gary''s Student "mark kubicki" wrote: in cell A1, I have a formula: =IF(INDIRECT("'Time Line'!a"&ROW())=0,"",INDIRECT("'Time Line'!a"&ROW())) How would I check for this condition in code? I'd tried using: if len(Range("A1") = 0 then... but it seems to evaluate the actual cell contents, not the result of the formula in the cell (consequently, the condition always checks TRUE) thanks in advance, mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Null as a result of an if? | Excel Discussion (Misc queries) | |||
| How do I set a result of an "if" function to NULL; not 0 or ""? | Excel Worksheet Functions | |||
| if A1=Null and B1=A1 why is result in B1=0 ?? | Excel Discussion (Misc queries) | |||
| Null Field Result in Loop | Excel Programming | |||
| Check null for range objects | Excel Programming | |||
Linear Mode
