Working with Criteria and formulas

[B.Kellough]

=IF(C2=1,"IAP",IF(D2=1,"PIP",IF(E2=1,"STEP","")))

Does anyone know if there is a way to change the formula above; and make it set a priority as to which result is displayed. Meaning=

If C2=1 and D2=1, the formula would aways bring back "PIP" showing that "D2" has a higher priority. With the way this works now it finds the first "1" and brings back the results for that and doesn't look for the second criteria.

Thanks for any help.

 

[JackDanIce]

Change the order of your testing conditions in your IF statement; the IF statement will always evaluate what it encouters first, so change it to:

=IF(D2=1,"PIP",IF(C2=1,"EAP",IF(E2=1,"STEP","")))

 

[MrKowz]

Try:

=IF(D2=1,"PIP",IF(C2=1,"IAP",IF(E2=1,"STEP","")))

 

[B.Kellough]

Thank you!

That works; goes to show sometimes we get stuck on something and forget to look at it from enough angles!

Thanks again

 

[T. Valko]

=IF(C2=1,"IAP",IF(D2=1,"PIP",IF(E2=1,"STEP","")))

Does anyone know if there is a way to change the formula above; and make it set a priority as to which result is displayed. Meaning=

If C2=1 and D2=1, the formula would aways bring back "PIP" showing that "D2" has a higher priority. With the way this works now it finds the first "1" and brings back the results for that and doesn't look for the second criteria.

Thanks for any help.

The priority is based on the sequence in which you have the conditional tests.

Maybe this is what you want:

=IF(OR(AND(C2=1,D2=1),D2=1),"PIP",IF(C2=1,"IAP",IF(E2=1,"STEP","")))