How to calculate a Low, Medium, High rating based on number criteria

[Debby223]

Hello

Can someone kindly help me write a formula that can display a column of numbers to a text rating (in a new column) of Low, Medium, High or Severe

The rating would be from:
[TABLE="******* 128"]
<colgroup><col width="64" span="2" style="*******48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, ******* 64"]1 to 6[/TD]
[TD="******* 64"]Low[/TD]
[/TR]
[TR]
[TD="class: xl63"]7 to 12[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]13 to 19[/TD]
[TD]High[/TD]
[/TR]
[TR]
[TD]over 20[/TD]
[TD]Severe[/TD]
[/TR]
</tbody>[/TABLE]


I had a previous formula that worked only by selecting individual numbers, but am struggling to do this where the number range is "between" 7 - 12, or 13 - 19

=IF($E5=9,"Severe",IF($E5=6,"High",IF($E5=4,"Medium",IF($E5=3,"Medium",IF($E5>=2,"Low",IF($E5=1,"Low", " "))))))


thank you so much


Debby

 

[Weazel]

maybe something like...

=LOOKUP(E5,{1;7;13;20},{"Low";"Medium";"High";"Severe"})

 

[Debby223]

Wonderful, thank you, that's works a treat

If you are able to, for my own learning and understanding, do the numbers {1;7;13;20} represent more than and less than?

Much appreciated.

 

[Weazel]

the lookup is doing an approximate match so essentially you're correct.

one thing to remember is the range you are looking up needs to be sorted ascending

 

[Debby223]

Thank you for taking the time to reply back.