Forum Discussion
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 thi...
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.