If Or Statement

[Robby19]

I am trying to have a cell state Compliant or Non-Compliant based off of results in other cells. I need TRS Compliance to say Compliant if, TRS Master = Y or MCTIMS - TRS = TA

My current formula for TRS Compliance,
=IF(OR([@EAS]<=Table1[today + 6 months],[@[TRS Master]]=""),"Non-Compliant","Compliant")

MCTIMS - TRS through Date Submitted are all Index(Match) formulas.
[TABLE="width: 500"]
<tbody>[TR]
[TD]MCTIMS - TRS[/TD]
[TD]MCTIMS - CAPSTONE[/TD]
[TD]TRS MASTER[/TD]
[TD]DATE ATTENDED[/TD]
[TD]DATE SUBMITTED[/TD]
[TD]DAYS TO EAS[/TD]
[TD]TRS COMPLIANCE[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD]5-Feb-18[/TD]
[TD]12-Mar-18[/TD]
[TD]88[/TD]
[TD]Non-Compliant[/TD]
[/TR]
</tbody>[/TABLE]

 

[Robby19]

My bust. I need TRS Compliance to say Compliant if, **EAS(Date) is greater than 180 days (6 months) from today** or MCTIMS - TRS = TA

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1048479-if-statement-based-criteria-repost.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.

As you have a reply in the other thread I've locked this one