=IF(S8="CLOSED","1","0")
Got that far... but need a final push

I need it to say - if =CLOSED 1
if =OPEN 0

If you feel so inclined to continue with my saga
Then I want these findings to carry over into colums B & C
B column IF(W8=1,"T8","")
C column IF(W8=0,"T8","")
am I headed in the right direction?

Thanks!!!!