I'm sorry, could you clarify a little more? I'm not awesome at these things.

"Bob I" wrote:

It is merely the replacement of E and P and D being L,M,H = 1,2,3
then Multiply E*P*D=result

Janessa wrote:

This was the original:
I am getting error messages for this:

=IF(D6=H,"27",IF(D6=M,"18", IF(D6=L,"9")))

I am trying to assign a value to a certain letter (High, Medium, Low). Is
this the wrong formula, or where do I need to make changes?

And I got a response, but then realized that results are a matrix, so there
are a total of 27 options. So if D6=H then E6 H=9, M=6, L=3 (and so on)

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



"Jeff" wrote:


could you combine your question in one thread, I am getting a little lost
jumping back and forth.

Thanks--
Jeff


"Janessa" wrote:


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