| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell
In a cell, I often want to reference another cell and want to return
"No value" or have it remain Blank, but the cell that I am referencing has a formula, so ISBLANK does not interpret that the referenced Cell is Blank. What formula can I use to return no value or leave the cell blank even though the referenced cell has a formula? Jim, Denver |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to not count cells which contain a formula that returns " "? | Excel Worksheet Functions | |||
| Multiple Offset/Match formula returns "#N/A" | Excel Discussion (Misc queries) | |||
| Finding cell that returns bad "solver_val" function. | Excel Discussion (Misc queries) | |||
| ISBLANK returns flase when there is nothing in the cell referenced | Excel Discussion (Misc queries) | |||
| Formula format in excel that returns an "error" if there is a blan | Excel Discussion (Misc queries) | |||
Threaded Mode
