If then statement for Risk Management Matrix

JDigrazia

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!

Paul Massam

Hi,

I just wrote the following but I called my dropdown column of Rating, so you'll see "Rating1" as the cell reference instead of "A1".

=IF(Rating1 = "Acceptable", 1, IF(Rating1 = "Tolerable", 2, IF(Rating1 = "Undesirable", 3, IF(Rating1 = "Intolerable", 4, ""))))

That will give you two columns as in the screenshot attached:

• One with the text: Acceptable, Tolerable, etc.
• The other with the score: 1; 2; 3; or 4

Is that what you meant?

 

 

JDigrazia

Thanks Paul.  This is perfect!