ExcelBanter - If Then

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Then (https://www.excelbanter.com/excel-worksheet-functions/160517-if-then.html)

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

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

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