Thread: Return a value to a cell that is blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default Return a value to a cell that is blank
Try this:

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

HTH,
Elkar


"hilltop55" wrote:

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.
Reply With QuoteReply With Quote