Categorizing # of seats into buckets

[rdzster]

I want to categorize the # of seats into buckets (1-5, 6-10, 11-20, 21-50, 51-100, 101-250, 251-500 and 500+).

So if the number of seats is 19, than the bucket would be 11-20.

Is there an easier equation than IF(OR?

Thanks!

 

[Smitty]

Welcome to the Board!

You can use a lookup table. You'll find some explanation and working examples here.

Just put your values in the left column and the bucket descriptions on the right.

HTH,

 

[snoopyhr]

or as an alternative :

Excel Workbook
	A	B	C	D	E
20	Lower Limits	Groups
21	1	1-5		No.	251
22	6	6-10		Group	251-500
23	11	11-20
24	21	21-50
25	51	51-100
26	101	101-250
27	251	251-500
28	501	500+
Sheet3

 

[rdzster]

Thanks for your help!! Works like a charm!