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