Getting Excel to recognise value ranges

[Diane Janicki]

I have a spreadsheet which calculates clients' ages, (in
years), in a cell. I need a formula which will look at the
age of the client, and then enter an age banding in the
adjacent cell.

eg: Client A is 25 years old, I want the adjacent cell to
produce the result "25-49"
Client B is 18 years old, I want the adjacent cell to
produce the result "18-25"

I've tried using >=18 and <=25, but it doesn't produce the
correct result. Any ideas?

 

[Frank Kabel]

Hi
if your age is in column A try the following formula
=IF(AND(A1>=18,A1<25),"18-24",IF(AND(A1>=25,A1<49),"25-48",IF(A1>=49,"a
bove 49", "under 18")))

 

[Guest]

Ah, Frank - you are a warm & wonderful human being. It
works! Thanks for your help