I am trying to calculate the level of risk for a particular item based on the user inputs to two fields.
Column A = Impact; drop down of values
Column B = Probability; drop down of values
Column C = Risk Level; calculated based on the entry in Column A and B and where they intersect in a matrix
<tbody>
</tbody>
<tbody>
</tbody>
Column A = Impact; drop down of values
Column B = Probability; drop down of values
Column C = Risk Level; calculated based on the entry in Column A and B and where they intersect in a matrix
A | B | C | |
1 | Impact | Probability | Risk Level |
2 | Medium | Unlikely | Low (but calculated by the formula) |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>