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
|