Thread: How do I leave formula cell blank if 2nd reference cell is empty?
View Single Post
  #3   Report Post  
Gary''s Student
 
Posts: n/a
Default How do I leave formula cell blank if 2nd reference cell is empty?
=IF(B1="","",A1+B1+1)
--
Gary's Student


"Liana S" wrote:

example:

cell a1 had date, cell b1 WILL HAVE a date in it. cell c1 has
formula=(a1+b1)+1.

I'd like cell c1 to display empty until cell b1 has data in it.

How do I do this?
Reply With QuoteReply With Quote