Data into age buckets

[gambils]

I have a large list with one columns that have age, gender and race. I need to sort the gender and race into the following age groups:

17 and under
18-64
65-84
85 and older


All that comes to mind to me is to do an if statement where I look at the age column and say, for instance, if it says age 18 in cell A1 they go in the 18-64 bucket and I place that result in B1. I have not ever done an if formula with so many conditions before so want to make sure I do the formula correctly.

Thanks!

 

[Peter_SSs]

what about you have text like days, months, and years?

Welcome to the MrExcel board!

Duplicate to Age group formula when you days, months, and years in TEXT

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.