Trouble combining IF/AND with or statement

[JREYNA03]

I am trying for the formula to recognize that either K4 or M4 will need to be active in order to return the result of "Cancel Plate"

IF(AND(G4="yes",I4="yes", (K4="Active"),OR (M4="Active"),(O4<TODAY(),R4="YES"),"Cancel Plates", "Do Not Cancel Plates")

 

[DanteAmor]

How about:

varios 27nov2023.xlsm
	A					F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1
2
3
4							yes		yes		Active				25-nov			yes		Cancel Plates
5							yes		yes				Active		25-nov			yes		Cancel Plates
6							yes		yes		Active		Active		25-nov			yes		Cancel Plates
7							yes		yes						25-nov			yes		Do Not Cancel Plates
Hoja5

Cell Formulas
Range	Formula
T4:T7	T4	=IF(AND(G4="yes",I4="yes",OR(K4="Active",M4="Active"),O4<TODAY(),R4="YES"),"Cancel Plates", "Do Not Cancel Plates")