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

563 thoughts on “IF function multiple text columns

  1. 출장

    This unique blog is without a doubt interesting and besides informative. I have picked a lot of interesting tips out of it. I ad love to return every once in a while. Cheers!

  2. Phentermine online kaufen

    Great website you have here but I was curious about if you knew of any message boards that cover the same topics talked about here? I’d really like to be a part of group where I can get responses from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Kudos!

  3. 출장샵

    Wow, wonderful blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your website is fantastic, let alone the content!

  4. 출장

    Wow, fantastic weblog format! How lengthy have you ever been blogging for? you made running a blog glance easy. The total glance of your web site is wonderful, let alone the content!

  5. anabolika kaufen

    I?¦m now not positive where you’re getting your information, but great topic. I must spend a while learning much more or working out more. Thanks for great info I was looking for this information for my mission.

  6. spritze anabole steroide online kaufen

    Hello just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Opera. I’m not sure if this is a format issue or something to do with web browser compatibility but I figured I’d post to let you know. The design look great though! Hope you get the issue solved soon. Kudos

  7. Reductil kaufen

    I think other web site proprietors should take this site as an model, very clean and fantastic user genial style and design, let alone the content. You are an expert in this topic!

  8. Buy phentermine HCL online

    Good day! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this write-up to him. Pretty sure he will have a good read. Many thanks for sharing!

  9. Comprar Melanotan 2 en línea

    Thanks for your personal marvelous posting! I actually enjoyed reading it, you are a great author.I will make certain to bookmark your blog and will come back sometime soon. I want to encourage that you continue your great work, have a nice day!

Comments are closed.