5x5 Risk management formula

Phil WightmanPhil Wightman ✭✭✭✭✭
edited 10/24/20 in Formulas and Functions
10/24/20 Edited 10/24/20
Answered - Pending Review

Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix.


I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified.


=IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 = "Insignificant"), "Low", IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible"), Consequence5 = "Minor"), "Low", IF(AND(OR(Likelihood5 = "Almost certain", ), Consequence5 = "Insignificant"), "Medium", IF(AND(OR(Likelihood5 = "Likely", Likelihood5 = "Almost certain"), Consequence5 = "Minor"), "Medium", IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible"), Consequence5 = "Moderate"), "Medium", IF(AND(OR(Likelihood5 = "Likely", Likelihood5 = "Almost certain"), Consequence5 = "Moderate"), "High", IF(AND(OR(Likelihood5 = "Rare"), Consequence5 = "Major"), "Medium", IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible"), Consequence5 = "Major"), "High", IF(AND(OR(Likelihood5 = "Likely", Likelihood5 = "Almost certain"), Consequence5 = "Major"), "Extreme", IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely"), Consequence5 = "Catastrophic"), "High", IF(AND(OR(Likelihood5 = "Possible", Likelihood5 = "Likely", Likelihood5 = "Almost certain"), Consequence5 = "Catastrophic"), "Extreme"))))))))))))

Answers

Sign In or Register to comment.