formulas

[geo]

what is the best way to leave a cell blank.

For example

Say in cell A1 I have a column of dates

In B1 I have a formula =A1+37 (days)

In C1 I have another formula = A1 +69 (days)


But say if A1 is blank I don't want anything to show
in B1 or C1

 

[BenjieLop]

what is the best way to leave a cell blank.

For example

Say in cell A1 I have a column of dates

In B1 I have a formula =A1+37 (days)

In C1 I have another formula = A1 +69 (days)


But say if A1 is blank I don't want anything to show
in B1 or C1

=IF(A1=\"\",\"\",YOUR_FORMULA_HERE)

Regards.

 

[RagDyeR]

Try these:

In B,
=IF(A1,A1+37,"")

In C,
=IF(A1,A1+69,"")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

what is the best way to leave a cell blank.

For example

Say in cell A1 I have a column of dates

In B1 I have a formula =A1+37 (days)

In C1 I have another formula = A1 +69 (days)


But say if A1 is blank I don't want anything to show
in B1 or C1