| 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 |
| 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 | |||
Threaded Mode
