If or function

[lilit2222]

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.

[JohnTopley]

See yellow banner at top of page on how to attach a workbook.

[lilit2222]

I have just attached it

[JohnTopley]

No w/book attached.

[lilit2222]

you should be able to see it now., sorry

[JohnTopley]

Try

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

[lilit2222]

thank you, works perfectly

[JohnTopley]

Shorter

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