Thread
:
Matrix question
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
Matrix question
Enter in C1:
=(CODE(A1)-65)*5 + B1
HTH
--
AP
"Cootha" a écrit dans le message de news:
...
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.
Reply With Quote