Highest value if using text

mtpark88

New member
Joined
Jul 15, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
21
If i have two columns, cost and schedule risk, with values "low", "moderate", "high" is there a way to use a formula to extract the highest risk from those two columns?
 

Attachments

  • Capture.PNG
    Capture.PNG
    3.4 KB · Views: 18
You mean?

=IF(OR(C2="High",E2="High"),"High",IF(OR(C2="Moderate",E2="Moderate"),"Moderate","Low"))


where C2 and E2 contain the possibilities
 
Back
Top