IF Function
They wouldn't tell me everything the first go-round would they. Thanks boss!
So they actually are looking with a matrix. So D6=Detectiblity, E6=Effect
and F6=Probability. Is there a formula to determine all of these and then
find the total?
Effect(side) Probability(top)
High Mod Low High Mod Low High Mod Low
High 27 18 9 18 12 6 9 6 3
Mod 18 12 6 12 8 4 6 4 2
Low 9 6 3 6 4 2 3 2 1
Low Moderate High
Detectability
|