Leaving a formula cell blank when data has not yet been added.
in [General]
|
Prev: Is there an Excel formula to round a date to the end of the month
Next: How to separate contents of one cell into multiple horizontal cell
From: SarahN on 20 May 2010 20:53 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
From: FSt1 on 20 May 2010 21:07 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 >
From: T. Valko on 20 May 2010 21:09 Try it like this... =IF(A1="","",A1+7) -- Biff Microsoft Excel MVP "SarahN" <SarahN(a)discussions.microsoft.com> wrote in message news:E2DBC4AE-B798-4A09-82CE-09B3353F136B(a)microsoft.com... > 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 >
From: SarahN on 20 May 2010 21:21 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 > >
From: FSt1 on 20 May 2010 21:39
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 > > > |