W
watermt
I have two validation lists, each have four options in their respective list
with ranges of 4 to 1. I need a formula that will display the results of the
selection in the Probability column x Severity of Effect column and display
the results under the Ranking column.
Probability Severity of Effect Ranking
Frequent x Catastrophic 16
Occasional x Major 9
Uncommon x Moderate 4
Remote x Minor 2
with ranges of 4 to 1. I need a formula that will display the results of the
selection in the Probability column x Severity of Effect column and display
the results under the Ranking column.
Probability Severity of Effect Ranking
Frequent x Catastrophic 16
Occasional x Major 9
Uncommon x Moderate 4
Remote x Minor 2