Using the If() Function for a percentage range

[season]

Does anyone know how to set up an equation, i assume using the If funtion but
maybe something else to pull from a percentage range. i cannot set it up to
work properly since it would have to say greater than a number then less than
a number. Example below.

% Range Word to list if true
0-5 None
6-25 Not Significant
26-60 Significant
61-100 Severe

Thanks so much, Season

 

[Tyro]

If I understand you, and your Percent is in A1 then in A2 put:

=LOOKUP(A1,{0,0.06,0.26,0.61},{"None","Not
Significant","Signifcant","Severe"})

Tyro

 

[season]

Thank you so much, that works perfectly.
Season

If I understand you, and your Percent is in A1 then in A2 put:

=LOOKUP(A1,{0,0.06,0.26,0.61},{"None","Not
Significant","Signifcant","Severe"})

Tyro

 

[Tyro]

You're welcome

Tyro

Thank you so much, that works perfectly.
Season