Hi,
I have created a risk log for which I need a formula to help calculate the overall risk rating.
In Column A, I am listing the Impact (Low, Medium, High) and in Column B, I am listing the likelihood (low, Medium, High).
I need a formula in column see that calculates the overall rating based on the first two columns.
I won't bother listing all of the possible ratings, but have listed a few as an example - if someone could give me the basic formula, I'm sure I can then add in all of the outcomes.
Impact Liklihood Overall Rating
Low Low Low
Medium Low Low
High Low Medium
Thanks in advance....
I have created a risk log for which I need a formula to help calculate the overall risk rating.
In Column A, I am listing the Impact (Low, Medium, High) and in Column B, I am listing the likelihood (low, Medium, High).
I need a formula in column see that calculates the overall rating based on the first two columns.
I won't bother listing all of the possible ratings, but have listed a few as an example - if someone could give me the basic formula, I'm sure I can then add in all of the outcomes.
Impact Liklihood Overall Rating
Low Low Low
Medium Low Low
High Low Medium
Thanks in advance....