| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Then
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Then
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
