IF AND OR Together

[Robby19]

I am trying to have a cell state Compliant or Non-Compliant based off other cells.

If TA Error = FALSE and Days to EAS - TRS Completion is greater than or equal to (>=) 180 show Compliant OR if Days to EAS is >= 180 show Compliant.

This is what I have so far, but it doesn't seem to work.
=IF(AND(OR([@[Days To EAS]=]=>=180),[@[TA Error]]=FALSE,[@[Days to EAS - TRS Completion]=]=>=180),"Compliant","Non-Compliant")

The TRS Compliance, where this formula is located, is sometimes displaying Non-Compliant when it should say Compliant, and vice versa.

TA	TA COMP DATE	DAYS TO EAS	DAYS TO EAS - TRS COMPLETION	TA ERROR	TRS COMPLIANCE
TA	18-APR-18	59	59	FALSE
#N/A		73	43281	TRUE
#N/A		237	43445	TRUE

<tbody>
</tbody>

 

[markmzz]

This seems to work perfectly. Thank you!

You are welcome.

Do some tests and tell us if works.

Markmzz