IF funcation (maybe???)???

My second problem is this

I have a field called “Age”. What I want to do is;

If I type in the person’s age say “26” then I want another cell to display an age range (i need to entered the age ranges i want eg “16-20, 21-29, 30-39” etc. So if I type in 26 in the first filed I want to second cell to display “20-29”.

Again, any help??

You can use a LOOKUP table either as a range or an inline array, eg

=LOOKUP(A1,{0,16,21,30,40},{"<16","16-20","21-29","30-39","40+"})

where A1 contains age (eg 26 per your ex.)

or this:

=IF(B1<21;"16-20";(10*(ROUNDDOWN(B1/10;0))+1)&" - "&(10*(1+ROUNDDOWN(B1/10;0))))