=LOOKUP(A1,{0,"GROUP 1";9,"GROUP 2";12,"GROUP 3";15,"GROUP 4"})
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Anna57" wrote:

Hello,

I have a list of ages (all to 2 decimal places) and i am trying to use an if
function to classify them into groups. Next to the list of ages i would like
another column indicating which group the individual falls in. Group
membership should follow the rules below:

age < 8 = group 1
age 9-11 = group 2
age 12-14 = group3
age 15+ = group 4

The formula i have put in is pasted below but it doesn't work, does anyone
know what might be wrong with it? I have used decimal numbers (e.g.11.99) for
the end of ranges as otherwise some ages will fall into more than one group:

=IF(A1=<8, "1", IF(A1=9:11.99, "2", IF(A1=12:14.99, "3", IF(A1=15, "4",
"0"))))

Any ideas? I have been tring for ages to see what's wrong but can't come up
with anything!




--
Anna