Aa

[tlai34]

Hi,

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]

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

 

[tlai34]

Thanks!