Need IF Statement help

[ArPharazon]

I have a pretty basic need, but I'm not sure ISBLANK is what I want.

I have a column with either blank cells, or dates/times.

I want the preceding column to show a 0 for the blank cells & a 1 for the populated cells.

I've tried this: =IF(D2="blank",0,IF(D2="not blank",1)) to no avail.

I'm not sure if I have the correct terms/nomenclature for the cells n "blank" and "not blank".

I used to use this formula for specific Work Order Statuses, when CLOSE, COMP, etc. were actually in the cells:
=IF(E2="COMP",1,IF(E2="CLOSE",1,IF(E2="APPR",0,IF(E2="INPRG",0,IF(E2="WSCH",0,IF(E2="WMATL",0,IF(E2="WVEND",0,IF(E2="WAPPR",0,IF(E2="WPCOND",0,"")))))))))

 

[Fluff]

How about
=If(D2="",0,1)

 

[mrhstn]

And for the second formula

=IF(ISNUMBER(MATCH(E2, {"COMP","CLOSE","APPR","INPRG"}, 0)), 0, IF(ISNUMBER(MATCH(E2, {"WSCH","WMATL","WVEND","WAPPR","WPCOND"}, 0)), 1, ""))

 

[ArPharazon]

How about
=If(D2="",0,1)

That worked perfectly. Thanks!

Someone had me try that with a * between the quotes as a wildcard,
but that didn't work so I figured a simple formula wasn't going to do it.

 

[ArPharazon]

And for the second formula

=IF(ISNUMBER(MATCH(E2, {"COMP","CLOSE","APPR","INPRG"}, 0)), 0, IF(ISNUMBER(MATCH(E2, {"WSCH","WMATL","WVEND","WAPPR","WPCOND"}, 0)), 1, ""))

I'm saving that formula in case I ever get to work with MAXIMO again and need to build a % Complete report.

 

[Fluff]

That worked perfectly. Thanks!

Glad to help & thanks for the feedback