Action status between two dates

[tlai34]

Sorry for reposting... seems like I can't edit yet.

I have 3 cells.

Cell I11 | Cell J11 | K11
Proposed completion date | Actual Completion Date | Action Status


What I want to do is have a formula that detects:

when I11 is not blank and J11 blank = open
when I11 is not blank and J11 is not blank = closed

ignore when I11 is blank.

Thanks

 

[shaowu459]

Please try：

=if(i11="","",if(j11="","open","closed"))

and i suggest not make duplicate post for the same question

 

[tlai34]

Sorry, tried editing the previous one, but couldn't.