Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matrix question
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix Problem | Excel Discussion (Misc queries) | |||
Pivot table question | Excel Discussion (Misc queries) | |||
Matrix calculation | Excel Discussion (Misc queries) | |||
How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
CORRELATION / COVARIANCE MATRIX | Excel Worksheet Functions |