Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ifblank function | Excel Worksheet Functions | |||
Help IfBlank use data from next cell | Excel Worksheet Functions | |||
if function and ifblank() function | Excel Worksheet Functions |