"HIGH MEDIUM LOW" Based on Result

[southike]

I have a sheet where cell R17 sums F17:Q17. I need to divide that sum by a fixed number in cell R16 and this will result in a percentage. Based on that percentage, I need it to show Low, Medium, or High. The criteria is as follows: 50% or less = LOW, 51% to 74% = MEDIUM, 75% or greater = HIGH. What is the best approach to this? Should I create a table and vlookup to that? Thank you.

 

[dreid1011]

A lookup table would likely be the most flexible option. Though if you don't plan on changing the values, you could put it all into a formula too.

 

[Sufiyan97]

Try

=IF(R17/R16>=0.75,"High",IF(R17/R16>=0.51,"Medium","Low"))

 

[Joe4]

If you have a lot of levels, or they may change from time-to-time, then a lookup table with VLOOKUP formula would be a good solution, as it makes it easy to update.
However, if you only have these 3 options and they will not change, then a simple formula like the one posted above would do the trick.