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

238 thoughts on “IF function multiple text columns

  1. Ty gia

    You are my aspiration, I possess few blogs and infrequently run out from brand . Follow your inclinations with due regard to the policeman round the corner. by W. Somerset Maugham.

  2. Sherryl Dumpe

    Very nice post. I just stumbled upon your weblog and wished to say that I’ve really enjoyed surfing around your blog posts. After all I will be subscribing to your feed and I hope you write again very soon!

  3. check

    Very nice post and right to the point. I am not sure if this is actually the best place to ask but do you people have any thoughts on where to employ some professional writers? Thx

  4. sling tv

    Fantastic items from you, man. I’ve take into
    account your stuff previous to and you are simply extremely excellent.
    I actually like what you’ve acquired here, certainly like what
    you’re saying and the way in which you say it. You make
    it entertaining and you still care for to stay it sensible.
    I cant wait to learn much more from you. This is actually a great web site.

  5. Olen Dirosa

    The wind is blowing my hair softly, and the leaves are gently floating beside you. Looking at the blue sky, sitting on the green grass, so warm and harmonious. I really want to stop this moment and let us be happy together for a lifetime!

Leave a Reply

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