Return a value if specific text is contained in range.

Hi All,

I would like to write a formula such that value is returned based on logic if value is contained in range (A2:I2).

My range contains two values "High" or "Low".

So,

1. If Range contains "High" then return "High"
2. If Range contains "Low" then return "Low"
3. If Range contains "Low" and "High" then return "High"
4. If Range contains neither "Low" nor "High" then return "Medium"

Can someone help please?

See the file test attached.

=IF(COUNTIF(A2:I2,"High")>0,"High",IF(AND(COUNTIF(A2:I2,"Low")>0,COUNTIF(A2:I2,"High")=0),"Low","Medium"))

Shorter ..

=IF(COUNTIF(A2:I2,"High"),"High",IF(COUNTIF(A2:I2,"Low"),"Low","Medium"))