qualitative risk level calculation

Originally Posted by dosydos

ok i just thought of something creative. try this if/choose statement.

Formula:

=CHOOSE(IF($A2="low",1,IF($A2="medium",2,IF($A2="high",3,"")))+IF($B2="low",1,IF($B2="medium",2,IF($B2="high",3,""))),,"low","low","medium","high","high")

this one worked just fine! thank you so much guys !!