Number range in an excel cell

[excelfrustrated]

HI, I'm preparing a risk assessment heat map that will assign numbers between a certain range a rating of low, medium or high. The numbers will be between 1 to 25 where 1-6 rate low; 7-15 rate medium and 16 - 25 rate high.

The heat map will be used in another table on another tab where the number ranges will represent the multiplication of a likelihood rank x impact. likelihood will be scored between 1 and 5 and the same for impact.

I hope I've made sense and someone can provide some assistance. Thank you in advance

 

[WingSystems]

=IF(VALUE<6,"Low",IF(VALUE<15,"Medium",IF(VALUE<25,"High")))

Some others with more experience may have a slicker way but that should work. Value would be the cell you are trying to assign a range.

 

[Peter_SSs]

Welcome to the MrExcel board!

Here is one other way to do it.

21 10 21.xlsm
	A	B
1	12	medium
2	23	high
3	24	high
4	6	low
5	10	medium
6	15	medium
lmh

Cell Formulas
Range	Formula
B1:B6	B1	=LOOKUP(A1,{1,7,16},{"low","medium","high"})