Return nothing if cell is populated

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
A formula cannot return nothing. However, it can return a null string,
e.g.:

=IF(ISBLANK(A1), "Cell A1 is not populated", "")
 
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")
 
Back
Top