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, EAS is greater than 6 months from today or the TRS Master = Y.
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.
<tbody>
</tbody>
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.
EAS | MCTIMS - TRS | MCTIMS - CAPSTONE | TRS MASTER | DATE ATTENDED | DATE SUBMITTED | DAYS TO EAS | TRS COMPLIANCE |
20180401 | Y | 5-Feb-18 | 12-Mar-18 | 88 | Non-Compliant |
<tbody>
</tbody>