Hi Folks -
I'd like to feedback to write a formula that evaluates the following:
=IF(Cell A1 "Acceptable" then???
Acceptable
Tolerable
Undesirable
Intolerable
"Then"...
the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2, "Undesirable" receives a 3 and finally Intolerable receives a 4. Note: The severity is a drop down list so I need the statement to have all 4 words and values associated.
What I plan on doing is then taking the severity scores and repeating it with likelihood.
Thank you!