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.
<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.
MCTIMS - TRS | MCTIMS - CAPSTONE | TRS MASTER | DATE ATTENDED | DATE SUBMITTED | DAYS TO EAS | TRS COMPLIANCE |
Y | 5-Feb-18 | 12-Mar-18 | 88 | Non-Compliant |
<tbody>
</tbody>