Getting Excel to recognise value ranges

  • Thread starter Thread starter Diane Janicki
  • Start date Start date
D

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?
 
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")))
 
Back
Top