IFBLANK
in [General]
|
From: mrtintheweb on 19 Apr 2010 05:58 I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated boxes that are blank but will show dates once data has been input. eg: A B C D 34 NAME DATE FUTUREDATE 35 John 15/03/10 =C35+(7*6) 36 D36 Cell shows as 11/02/1900 when C36 is not populated but want i to show blank until it is populated when I want the formula to kick in. Toby
From: Mike H on 19 Apr 2010 06:03 Hi, try this =IF(C36="","",C36+(7*6)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "mrtintheweb" wrote: > I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated > boxes that are blank but will show dates once data has been input. > > eg: > A B C D > 34 NAME DATE FUTUREDATE > 35 John 15/03/10 =C35+(7*6) > 36 > > D36 Cell shows as 11/02/1900 when C36 is not populated but want i to show > blank until it is populated when I want the formula to kick in. > > Toby
From: Jacob Skaria on 19 Apr 2010 07:26 =IF(C35,C35+(7*6),"") -- Jacob (MVP - Excel) "mrtintheweb" wrote: > I have a spreadsheet that has dates in. The spreadsheet needs pre-poulated > boxes that are blank but will show dates once data has been input. > > eg: > A B C D > 34 NAME DATE FUTUREDATE > 35 John 15/03/10 =C35+(7*6) > 36 > > D36 Cell shows as 11/02/1900 when C36 is not populated but want i to show > blank until it is populated when I want the formula to kick in. > > Toby
|
Pages: 1 Prev: Key Board shortcut to Status bar Next: How to retrieve the value within string? |