View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spence
 
Posts: n/a
Default cell value based on null/not null in another cell

I would like to write a formula in cell C23 so that this cell will display as
empty if cell A23 is empty (null) but will pull the value from cell A1 if A23
has a value entered into it. I have spent some time working in Access but my
knowledge of Excel sytax is limited.

Thanks in advance