Return nothing if cell is populated
 

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


Any ideas?

Return nothing if cell is populated
 

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


Any ideas?



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.

Return nothing if cell is populated
 

=IF(A1="","X","")


--
Gary''s Student - gsnu200752


"whatzzup" wrote:

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


Any ideas?

Return nothing if cell is populated
 

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

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

In article ,
whatzzup wrote:

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


Any ideas?

Return nothing if cell is 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")




whatzzup wrote:

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

Any ideas?

--

Dave Peterson