Return nothing if cell is populated

G

Guest

I am looking for a formula that will examine cells a cell and return nothing
if another cell is populated with anything.


Any ideas?
 
S

Stephen

whatzzup said:
I am looking for a formula that will examine cells a cell and return
nothing
if another cell is populated with anything.


Any ideas?
Click to expand...

The obvious question is: what should it return if the other cell is not
populated?
You probably want something along these lines:
=IF(A1="",xxxxxxxx,"")
where xxxxxxxx is what you want if the other cell is not populated.
 
J

JE McGimpsey

A formula cannot return nothing. However, it can return a null string,
e.g.:

=IF(ISBLANK(A1), "Cell A1 is not populated", "")
 
D

Dave Peterson

You can return an empty string, but you can't return nothing (leave the cell
empty):

=if(a1<>"","",a1)
or
=if(a1<>"","","it's empty")
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Return value of a non blank cell 10
Help needed 0
Last populated cell in a column 9
Create Drop Down Box populated by a List 1
Cells display nothing IF 8
Trying to run excel vba code when cell value changes from empty to entered value. 1
formula for a cell which is blank returns populated cell 1

Top