If/AND/OR Formula for 3 way solution

[Skye123456]

Please refer to attached image. I want the cell titled "current status" aka column D to have 3 rules. I can't get the formula right. This is what I've used:



=IF(AND(B2>0,"Closed","Open"), OR(E2>0,"","open"))

* Column B's cells references another cell on a different tab which is a date. If there is date(B2>0), then D2 equal blank, but if there is a date, D2 equals open. However,

*E Column's cells references a date too. If E2 is blank, then E2 is open. If there is a date, then E2 = closed.

Basically I have upload a picture from excel that has three rows highlighted demonstrating the three scenarios. I don't know if this is all possible or not though.