isempty function is not working to show value if cell is empty

Hi,

In the attached file the VBA is a isempty function to display the following.

1. if column E shows completed and if column K has a date , in column J its supposed to show as Yes.
2. if column E shows completed and if column K is empty, in column J its supposed to show as No.

Item 1 is working but item 2 is not working.

Additionally if i could get some advice to add

3. if column E shows open and if column K is empty, in column J its supposed to show as Open.
4. if column E shows cancelled and if column K is empty, in column J its supposed to show as cancelled.