# AND,OR AND IF FUNCTIONS? HELP

Occasional Visitor

# AND,OR AND IF FUNCTIONS? HELP

i wish to express the following range of scores in a single cell that will then appear in type as either low, medium or high, based on a given score:

 Low 10-24, Medium 25-34, High 35-50

this is the formula i have created so far =IF(AND(H8>=10,H8<=24),"Low") which has given me "Low" but i cannot figure out how to include medium or high in the formula! can anyone spare the time to write out the appropriate formula? please and thank you, Dylan

2 Replies

# Re: AND,OR AND IF FUNCTIONS? HELP

``=XLOOKUP(H8,{10,25,35},{"Low","Medium","High"},,-1,1)``

# Re: AND,OR AND IF FUNCTIONS? HELP

I would like to suggest two possible formula one is standard IF,, AND another is little tricky.

``=IF(AND(H8>=10,H8<=24),"Low",IF(AND(H8>=25,H8<=34),"Medium",IF(AND(H8>=35,H8<=50),"High","No Data")))``

Another is:

``=VLOOKUP(\$H\$8,{10,"Low";25,"Medium";35,"High";51,"No Data"},2)``

• Adjust cell references in the formula as needed.