View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.