Leaving a formula cell blank when data has not yet been added.
 

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance

Leaving a formula cell blank when data has not yet been added.
 

hi
=if(A2="","",A2+7)
or
if a2 is blank then blank else a2+7
the formula will show in the formula bar but the cell on the sheet will be
blank.

regards
FSt1

"SarahN" wrote:

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance

Leaving a formula cell blank when data has not yet been added.
 

Try it like this...

=IF(A1="","",A1+7)

--
Biff
Microsoft Excel MVP


"SarahN" wrote in message
...
Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in
cel
A2 is entered.

I enter a number of furmulas into cells where there is no information
being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance

Leaving a formula cell blank when data has not yet been added.
 

Awesome Thanks.

How would this work if I am using NETWORKDAYS in cell C3? Formula

=NETWORKDAYS(A2,A3)-1

Is it the same formula to leave cell C3 blank until the data is entered into
Cells A2 and A3?

Thankyou again.

"FSt1" wrote:

hi
=if(A2="","",A2+7)
or
if a2 is blank then blank else a2+7
the formula will show in the formula bar but the cell on the sheet will be
blank.

regards
FSt1

"SarahN" wrote:

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance

Leaving a formula cell blank when data has not yet been added.
 

hi again
yes, it would work the same way.
=if(and(A2="",A3=""),"",networkdays(A2,A3)-1))
or
if both a2 and a3 are blank then blank else do the networkdays formula.

again the formula will show in the formula bar but the cell on the sheet
will be blank untill something is enter in both a2 and a3. it is not a data
qualifer. if you enter something like "oddball" or something that excel
cann't interpet as a date then the result will be the #value error.

regards
FSt1

"SarahN" wrote:

Awesome Thanks.

How would this work if I am using NETWORKDAYS in cell C3? Formula

=NETWORKDAYS(A2,A3)-1

Is it the same formula to leave cell C3 blank until the data is entered into
Cells A2 and A3?

Thankyou again.

"FSt1" wrote:

hi
=if(A2="","",A2+7)
or
if a2 is blank then blank else a2+7
the formula will show in the formula bar but the cell on the sheet will be
blank.

regards
FSt1

"SarahN" wrote:

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance

Leaving a formula cell blank when data has not yet been added.
 

That is great. Thankyou so much for your time.



"FSt1" wrote:

hi again
yes, it would work the same way.
=if(and(A2="",A3=""),"",networkdays(A2,A3)-1))
or
if both a2 and a3 are blank then blank else do the networkdays formula.

again the formula will show in the formula bar but the cell on the sheet
will be blank untill something is enter in both a2 and a3. it is not a data
qualifer. if you enter something like "oddball" or something that excel
cann't interpet as a date then the result will be the #value error.

regards
FSt1

"SarahN" wrote:

Awesome Thanks.

How would this work if I am using NETWORKDAYS in cell C3? Formula

=NETWORKDAYS(A2,A3)-1

Is it the same formula to leave cell C3 blank until the data is entered into
Cells A2 and A3?

Thankyou again.

"FSt1" wrote:

hi
=if(A2="","",A2+7)
or
if a2 is blank then blank else a2+7
the formula will show in the formula bar but the cell on the sheet will be
blank.

regards
FSt1

"SarahN" wrote:

Hi,

I am creating a worksheet that will be completed by a number of people.

I have a date formula


A B C
1 10/02/2010 =A1+7 (17/02/2010)
2 Blank =A2+7 (07/01/1900)

Is there any way to make Cell C2 remain blank until the information in cel
A2 is entered.

I enter a number of furmulas into cells where there is no information being
entered yet as it is a blank worksheet, is there a common way to have the
cells remain empty until the data cells have information in them?

I hope I have not confused anyone.

Thanks for your help in advance