If Then

[Guest]

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

 

[Guest]

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",""))

 

[Guest]

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",""))