I am working with a Risk List. I have a column called Probability of
Occurrence and another column called Impact if Occurs. Both columns are
populated with L, M, or H (for Low, Medium and High).

What I want to do is to create a third column called Risk Score. To
determine the Risk Score I need to assign numerical values to L, M, and H in
the Probability and Impact columns and then multiply the two columns
together.

So, for example if I have a risk that has a low probabilty of occurrence (L
= 1) but will have a high impact if it occurs (H=9), I want the Risk Score
column to show a 9.

I have tried playing around with the IF statement, and I know it can be
nested as shown in Excel help, but how would I write the statement to do IF
statements for 2 separate columns and then multiply those columns together?
Is this even possible?

--
Thanks,
Carolyn G, PMP