qualitative risk level calculation

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")