Calculated Column Update – SharePoint Exchange Stack

I have this calculated column formula for stop lights and I just need a little help to tweak this formula.

= IF (OR ([Date Needed]* <Today, date + 90<Today), "red", IF (OR (modified + 15<* Today, Status = "project"), "yellow", "green"))

The additional requirement is to have all statuses equal to closed = green instead of red. The red light marks them in red because the [modified date] is> 15 days. Any help is appreciated!

Also, I put the * for the complete formula to appear. I'm pretty new here …

Thank you