IF Statements to create 4 different Buckets=Value

[davidgarcia100]

I have a series of numbers in a column from 1 - infinity that I want to catagorize into Four buckets. I think that you would use the IF statement but I am not sure as it is four different categories.

The Four Categories Are:

0 = Zero
1-10 =Small
11-90 = Medium
91+ = Large

Thank you in advance!!!!!

David

 

[pplstuff]

I'm not sure what the question is, but if you're just looking for the word you can use if() or vlookup().

=if(__=0,"Zero",if(and(__>=1,___<=10,"Small"),if(and(__>=11,__<=90),"Medium",if(__>=91,"Large","No Bucket"))))

Keep in mind, in your OP you account for .5, 10.5, 90.5.

 

[davidgarcia100]

Basically I want the excel to put a certain value in cell Z9 for each number.

If the number is between 1 and 10 in Z9 I want Z10 to say Small.

I tried your formula when changing the __ to Z9, the Zero Works, however for everything else I get a VALUE error.

Do you know what is wrong?? Thanks in advance!!

 

[pplstuff]

=IF(B3=0,"Zero",IF(AND(B3>=1,B3<=10),"Small",IF(AND(B3>=11,B3<=90),"Medium",IF(B3>=91,"Large","No Bucket"))))

Sorry, one of the ")" was off. Try that, and replace b3.

 

[Trouttrap2]

You might try the lookup function.

=LOOKUP(A1,{0,1,11,91},{"Zero","Small","Medium","Large"})