Using IF and CONTAINS in one formula
I am trying to create a formula that returns:
Tolerable if the answer is Low
Tolerable if the answer is Medium
Acceptable if the answer is High
Acceptible if the answer contains Urgent.
I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas.
=IF(Answer@row = "Yes", "Acceptable", IF(Answer@row = "No", "Undesirable", IF(Answer@row = "Not Applicable", "Tolerable", IF(Answer@row CONTAINS "Urgent", "Acceptable))))
I am getting lost at the "CONTAINS" part.
Best Answer

=IF(OR(CONTAINS("Yes",Answer@row),CONTAINS("Urgent","Answer@row)),"Acceptable", IF(CONTAINS("No",Answer@row), "Undesirable", IF(CONTAINS("Not Applicable",Answer@row),"Tolerable","")))
I believe that should do it. I combined both your variables that yield acceptable.
Answers

=IF(OR(CONTAINS("Yes",Answer@row),CONTAINS("Urgent","Answer@row)),"Acceptable", IF(CONTAINS("No",Answer@row), "Undesirable", IF(CONTAINS("Not Applicable",Answer@row),"Tolerable","")))
I believe that should do it. I combined both your variables that yield acceptable.
Help Article Resources
Categories
Check out the Formula Handbook template!