Hi everyone out there,
I have a spreadsheet (3 columns) and two of the columns have five possible
inputs.
"Column A" has the following possibilities - Always (A), Likely (B),
Possible (C), Unlikely (D) and Rare (E).
"Column B" has the following possibilities -Insignificant (1), Minor (2),
Moderate (3), Major (4) and Catastrophic (5).
I need "Column C" to return a value between 1 and 25 (with each number
corresponding to a particular combination of the input from columns A and B).
Have tried the IF formula, and it worked up to 7 values. Is there any other
way to have up to 25 combinations of outcomes from my two columns, or some
other formula that is more appropriate?
Thanks in advance for helping out.