Need formula like ISBLANK that returns "no value" even if there is a formula in referenced cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

insitedge - 07 May 2008 13:12 GMT

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 to this Message

Pete_UK - 07 May 2008 13:27 GMT

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

> 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
[quoted text clipped - 4 lines]
> Jim,
> Denver

Reply to this Message