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
|