IF function multiple text columns

Hi,

I am trying to display the final risk classification based on two text columns. In column A i have one of five predefined values (rare, unlikely, etc.) and in column B other five options from a different criteria (insignificant, minor, etc.). In the table below are the values and combinations.

In columns C I want to display of it is a low, importnat, significant or major risk based on the combinations displayed.

How can I do thsi with and IF fucntion?

 

Probability

Rare
5%

Unlikely 25%

Moderate 50%

Likely
75%

Almost Certain 95%

Exposure

Insignificant

 

Low

Low

Low

Important

Important

Minor

 

Low

Low

Important

Significant

Significant

Moderate

 

Low

Important

Significant

Significant

Major

Major

 

Important

Significant

Major

Major

Major

Catastrophic

 

Important

Significant

Major

Major

Major

Thanks.

 

Regards,

Petya

 

By: Petya

Leave a Reply

Your email address will not be published. Required fields are marked *