Forum Discussion

lbrosten's avatar
lbrosten
Copper Contributor
Oct 31, 2021
Solved

Formula for selecting text based on conditions

In need of a formula for column C Risk Level which = The text representing the highest risk between Column A Audit Risk Level and Column B Perceived Risk Level   For Example    
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 31, 2021

    lbrosten 

    =IF(OR(A4="High",B4="High"),"High",IF(OR(A4="Medium",B4="Medium"),"Medium","Low"))

     

    Is this the formula you are looking for?

lbrosten's avatar
lbrosten
Copper Contributor
Oct 31, 2021

Thank you . Almost perfect. It's not working for the scenario where column A is a higher risk than column B. 

 

OliverScheurich 

Resources