If Then

N

nabanco

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
 
N

nabanco

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

bj

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