IFS Greater Than & Less Than

[thooley6]

Hi,
I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated.

The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band.

So I need to combine the following into one formula:

If age is <=17, it needs to equal "J"

If age is 18-21 inclusive, it needs to equal "YA"

If age is 22-59 inclusive, it needs to equal "A"

If age is >=60 it needs to equal "S"


Thanks in advance for your help!

 

[Phuoc]

Try this:

=LOOKUP(A1,{1,18,22,60},{"J","YA","A","S"})

 

[thooley6]

Brilliant, that's worked! Thanks