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" 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.

=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?

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?

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