Hey all, first post so fingers are crossed.

Ok I have made the formula below and it works fine.

=IF(AC4>26,"EXCELLENT",IF(AD4>22,"ABOVE AVERAGE",IF(AD4>17,"AVERAGE",IF(AD4>13,"BELOW AVERAGE",IF(AD4<12,"POOR")))))

My problem is I have a bunch of variables that need to be in there and apparently I am not smart enough to figure it out.

For ex. I need four age groups where all the numbers will be diffrent for males and four for females.

In this case, gender would be in column C (and would use 1 for male and 2 for female) age will be in column E.

The above formula would be for age 20-29 but is not sorted by gender.

Hope all that makes sense?????

Thanks in advance