Using the If() Function for a percentage range
 

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

Using the If() Function for a percentage range
 

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" wrote in message
...
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

Using the If() Function for a percentage range
 

Thank you so much, that works perfectly.
Season

"Tyro" wrote:

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" wrote in message
...
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

Using the If() Function for a percentage range
 

You're welcome

Tyro

"season" wrote in message
...
Thank you so much, that works perfectly.
Season

"Tyro" wrote:

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" wrote in message
...
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