| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need formula like ISBLANK that returns "no value" even if thereis a formula in referenced cell
You won't be able to get a true blank, as the cell contains a formula.
If that formula returns a blank ("") however, you can use something like this: =IF(A1="","",something_else) Hope this helps. Pete On May 7, 1:12*pm, insitedge wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
