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!
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!