View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Return a value to a cell that is blank

Try this:

=IF(A2="",A3,"")

Biff

"hilltop55" wrote in message
...
Cell A2 is blank, I want a formula to look at A2 if it is blank I want to
return the value from A3; if cell A2 is not blank do nothing.
--
Thanks for your help.