AND,OR AND IF FUNCTIONS? HELP

Occasional Visitor

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

@dylanryan 

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

@dylanryan 

 

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.