ExcelBanter - How do I leave formula cell blank if 2nd reference cell is empty?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I leave formula cell blank if 2nd reference cell is empty? (https://www.excelbanter.com/excel-discussion-misc-queries/51623-how-do-i-leave-formula-cell-blank-if-2nd-reference-cell-empty.html)

Liana S

How do I leave formula cell blank if 2nd reference cell is empty?

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?

Dave O

How do I leave formula cell blank if 2nd reference cell is empty?

The formula in C1 would be
=IF(B1="","",A1+B1+1)

Gary''s Student

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?

All times are GMT +1. The time now is 12:45 PM.