# Risk Assessment Calculation

#### bw5727

##### New Member
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

 A B C 1 Impact Probability Risk Level 2 Medium Unlikely Low (but calculated by the formula)

<tbody>
</tbody>

 A B C D E F 1 Negligible Low Medium High Severe 2 Almost Certain Medium High High Extreme Extreme 3 Very Likely Medium Medium High High Extreme 4 Likely Low Medium Medium Medium High 5 Unlikely Low Low Low Medium Medium 6 Rare Low Low Low Low Medium

<tbody>
</tbody>

<tbody>
</tbody>

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

#### Fluff

##### MrExcel MVP, Moderator
Hi & welcome to MrExcel

#### bw5727

##### New Member
That worked! THANKS SO MUCH!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback

Replies
1
Views
290
Replies
4
Views
351
Replies
3
Views
41
Replies
5
Views
448
Replies
1
Views
252