formulas

G

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
 
B

BenjieLop

geo said:
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
Click to expand...

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

Regards.
 
R

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
 
Top