|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 19th, 2010, 10:58 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
IFBLANK
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 
|
|
#2
April 19th, 2010, 11:03 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFBLANK
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
|
|
#3
April 19th, 2010, 12:26 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
IFBLANK
=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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
