nested If

[RUDYTX]

Hello!
I need help with this formula. Right now this formula is true if all the values in red are E, 1, N or all the values in blue are E, 1, N
Sometimes my data base wont have data in red or blue, and sometimes will have both. When it has data in red and blue i want my formula to consider the data in blue and ignore the data in red to be true.

Thanks in advance

	A	B	C	D	E	F	G	H	I	J	K
1
2
3	10	STD	4	4	E	1	N	E	1	N	YES
4

<tbody>
</tbody>

K3:
=IF((AND(A3=10,OR(B3="STD",AND(C3=4,D3=4)),OR(AND(E3="E",F3=1,G3="N"),AND(H3="E",I3=1,J3="N")))),"YES","NO")

 

[RUDYTX]

It worked fantastically!. Thanks so much jasonb.