Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help! IF functions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |