# Complex IF Statements

#### Zmaxx

##### New Member
Hi Guys

I am trying and struggling to create a nested IF statement for risk assessment that works this way:
The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low, low....high. Now the part where I'm struggling is:
#Each consequence range (1-7) has it's own criteria for whether a value is considered very low, low etc.
#I want to create an IF statement that will first check the value of consequence, then based on that value it will check the value of the product (consequence x probability) and return very low, low, torable etc
For example:
Consequence = 1, Probability = 4
Risk Score = 1×4 = 4
Risk Category = Low

Consequence = 2, Probability = 6
Risk Score = 2x6 = 12
Risk Category = Tolerable

What is the best way to approach this? Thank You

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### AlanY

##### Well-known Member
firstly, you need to define the ranges for the very low, low & high categories.

secondly, let say score 12 = tolerable, does it matter if it's resulted from 2x6 or 3x4 etc?

#### Zmaxx

##### New Member
I managed to do it by creating a grid table with the labels and used a combination of VLOOKUP and MATCH to find the point of intersection for each possible combination. Thank You

1,102,026
Messages
5,484,258
Members
407,436
Latest member
Szafranski

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...