depending on priorities one of these two should do it.

=if(J2="MCB","Yes",IF(A2="X","Complete",IF(OR(AND( R2=7,R2<=100),AND(S2=1,S2<=100)),"YES","")))
or
=IF(A2="X","Complete",IF(OR(J2="MCB,AND(R2=7,R2<= 100),AND(S2=1,S2<=100)),"YES",""))



"nabanco" wrote:

Sorry, her's the formula for the below question

=IF(A2="X","Complete",IF(OR(AND(R2=7,R2<=100),AND (S2=1,S2<=100)),"YES",""))


"nabanco" wrote:

Hello,

How would I cahnge the below formula to add a criteria that if the J column
says "MCB", then the answer would be "Yes"

Thank you