If statement with 3 outcomes

Hello

Can someone help me with this issue.

see attached excel workbook.

I want a formula in the status columm (D) which returns me the text "CLOSED" "OVERDUE" "OPEN"


1. if the due date and completed date is 0 it will say "closed"

2. When the completed date is less than 0 i want it to say "closed"

3 if the completed date does not have a completed date and is less than the due date "open"

4. if the completed date does not have a completed date and is larger than the due date "Overdue"

i have tried diffrent combinations of the if statement but i can not figure it out.
Overdue Excel.xlsx

Well that helped. Thank you