IF Function

  • Thread starter Thread starter madeline
  • Start date Start date
M

madeline

Hello!
OK, I have a set of data of unemployment in different areas of a city.
I therefore have column (A) of districts in the city and column (B) o
unemployment percentages (ranging from 0-44%).

I am trying to use the IF function to categorize these unemploymen
levels into 'low' (under 15%), 'moderate' (16-30%) and 'high' (31-45%
levels of unemployment using the IF Function, but i don't understan
what i need to write in the "Logical_test" , or how to go about it...


I dont know what 'count' and sum' mean, but have previously done a
exercise selecting 'logical' and 'if' from the function box ?!

Thanks muchl
 
Hi

if you want to show the result in column C enter the following formula
in C1
=IF(B1<0.16,"low",IF(B1<0.31,"moderate","high"))

in your example you haven't been precise what should happen to values
like 15% or 15.1 % as well as 30%. The formula above treats all values
below 16% as 'low'. maybe you have to change these values

Frank
 
OK.
If you want to know the count of those in col A for section 1 and col B for
mid
=sumproduct((a2:a200=1)*(b2:b200>=16)*(b2:b200<30))
 
Hi, I have used a similar formula for a traffic light
system. Try the following.

IF(b2<15,"LOW",if(b2>=31,"HIGH","MODERATE"))

To give it a nice touch you can then use conditional
formatting to colour the different Status.

Go to Format, Conditional Formatting and add three
entries.

Cell Value is Equal to ="HIGH"
Cell Value is Equal to ="LOW"
Cell Value is Equal to ="MODERATE"

You can format each condition with a different colour to
produce a traffic light system.

Regards

Mark
 
i have tried your suggested formulas, but none of them seem to wor
correctly, because it makes most of them "HIGH" when they are not!
I am wanting the formula to be that:
if the value is 0-15 = LOW
if the value is 16-30 = MODERATE
if the value is 31-44 = HIGH
:
 
Hi
first of all your ranges are not well defined. e.g. waht will happen to
a value like 15,5%. Its neither low or moderate according to your
example.

for your problem. Have you entered the percetages as percent values or
entered as number without the '%'.
Frank
 
OK Madeline, send me a small copy of your problem along with exactly what
you want to the address below
 
One more option

=VLOOKUP(B2,{0,"Low";0.16,"Moderate";0.31,"High"},2,TRUE

This will check the value in B2. A value of 15.5% will return Low. Also this formula assumes the percentage are entered as decimals or percents

Regards
Mark Graesse
(e-mail address removed)

----- madeline > wrote: ----

Hello
OK, I have a set of data of unemployment in different areas of a city.
I therefore have column (A) of districts in the city and column (B) o
unemployment percentages (ranging from 0-44%)

I am trying to use the IF function to categorize these unemploymen
levels into 'low' (under 15%), 'moderate' (16-30%) and 'high' (31-45%
levels of unemployment using the IF Function, but i don't understan
what i need to write in the "Logical_test" , or how to go about it...


I dont know what 'count' and sum' mean, but have previously done a
exercise selecting 'logical' and 'if' from the function box ?

Thanks muchl
 
Back
Top