Results 1 to 2 of 2

Thread: Highest value if using text

  1. #1
    Neophyte mtpark88's Avatar
    Join Date
    Jul 2019
    Posts
    1
    Articles
    0
    Excel Version
    21

    Highest value if using text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	14 
Size:	3.4 KB 
ID:	9252  

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,512
    Articles
    0
    Excel Version
    Excel 2016
    You mean?

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


    where C2 and E2 contain the possibilities


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •