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

I

insitedge

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

isblank 2
formula finds values in apparently blank cells 1
If null, make cell blank 1
VALUE appearing (referencing blank cell) 3
Need correct IF(ISBLANK) formula when referencing whether one of twocells (OR) is blank, returning " 3
How do I put a blank value in a cell not using "" in a formula 2
Want blank cell displayed if indirectly referenced value is zero 3
returning blank when reference cell is blank 4

Top