L
Luc
My problem :
I have 2 cells:
One cell is named "Severity" (allowed inputs are L, M, H)
The second cell is named "Probability" (allowed inputs are also L, M, H)
I want the third cell (named "Risk") to contain the result of "Severity" and
"Probability", which is retrieved from the 'Riskmatrix'
Example of the matrix (the name of this matrix is "Riskmatrix")
L M H (Row severity= first row)
H x y z
M x1 y1 z1
L x2 y2 z2
Column Probability (= first column)
Example :
Severity = M
Probability = L
=> Value of Risk cell should be y2
What formula should i put in the Risk cell?
Thanxxxxx,
Luc
I have 2 cells:
One cell is named "Severity" (allowed inputs are L, M, H)
The second cell is named "Probability" (allowed inputs are also L, M, H)
I want the third cell (named "Risk") to contain the result of "Severity" and
"Probability", which is retrieved from the 'Riskmatrix'
Example of the matrix (the name of this matrix is "Riskmatrix")
L M H (Row severity= first row)
H x y z
M x1 y1 z1
L x2 y2 z2
Column Probability (= first column)
Example :
Severity = M
Probability = L
=> Value of Risk cell should be y2
What formula should i put in the Risk cell?
Thanxxxxx,
Luc