Forum Discussion
Excel formula
I have 7 criteria ages groups, 0-1 Years, 2-4 Years, 5-12 Years, 13-18 Years, 19-30 Years, 31-59 Years, and 59+ Years. (1) Infants, (2) Toddlers, (3) Juniors, (4) Youth, (5) Y-Adults, (6) Adults, and (7) Seniors. I want a formula that will automatically add the criteria to the age. pls help! Johan
=IF(A1>59,"Seniors", IF(A1>30,"Adults", IF(A1>18,"Y-Adults", IF(A1>12,"Youth", IF(A1>4,"Juniors", IF(A1>1,"Toddlers", "Infants"))))))
Note: Change 'A1' to relevant reference cell in your worksheet
12 Replies
=IF(A1>59,"Seniors", IF(A1>30,"Adults", IF(A1>18,"Y-Adults", IF(A1>12,"Youth", IF(A1>4,"Juniors", IF(A1>1,"Toddlers", "Infants"))))))
Note: Change 'A1' to relevant reference cell in your worksheet
Thanks for coming back so soon. Doest seem to work !!!i have attached the error
seems like have made an error in number of brackets...
can u pls send screenshot of the formula in your worksheet?
