If nested formula - all same result

[toony]

Hi. I am grouping ages using the below formula but all gives "Adult" if you can help me please. I've tried to change the > and < symbols but to me the below makes sense and don't really know what i'm doing wrong if you can help please.
=IF([@Age]>=18,"Adult",IF([@Age]>=40,"Mature","Senior"))

 

[Toadstool]

Hi Toony,

It find greater than 18, sets "Adult" and ends execution. You don't cater for aged less than 18 or define when a Senior age starts, so I've added more checks.

Toony.xlsx
	A	B	C
1	Name	Age	Result
2	Bob	44	Mature
3	Sue	66	Senior
4	Jim	33	Adult
5	Kim	18	Adult
6	Olive	17	Youngster
7	Vera	5	Youngster
Sheet1

Cell Formulas
Range	Formula
C2:C7	C2	=IF([@Age]>=65,"Senior",IF([@Age]>=40,"Mature",IF([@Age]>=18,"Adult","Youngster")))

Named Ranges
Name	Refers To	Cells
Age	=Sheet1!$B$2:$B$7	C2

 

[toony]

That's perfect it works as it should. I knew it was something to do with what you mentioned of not setting the ages right. I was looking forward to the explanation itself rather than the solution to it. I love the explanation and have taken a good note of it. Cheers

 

[Toadstool]

That's perfect it works as it should. I knew it was something to do with what you mentioned of not setting the ages right. I was looking forward to the explanation itself rather than the solution to it. I love the explanation and have taken a good note of it. Cheers

You're welcome.

 

[DanteAmor]

Another way:

Dante Amor
	A	B	C
1	Name	Age	Result
2	Bob	44	Mature
3	Sue	66	Senior
4	Jim	33	Adult
5	Kim	18	Adult
6	Olive	17	Youngster
7	Vera	5	Youngster
Hoja5

Cell Formulas
Range	Formula
C2:C7	C2	=LOOKUP([Age],{0,18,40,65},{"Youngster","Adult","Mature","Senior"})

 

[toony]

=LOOKUP([Age],{0,18,40,65},{"Youngster","Adult","Mature","Senior"})

I like it actually but haven't dealt much with array formulas and can't make it work sorry.
I've presss Shif+Control+Enter but I don't think that am doing it right. So I ended entering the curl brackets manually...but obvioiusly didn't work either.
If you can help with it please, though not easy to explain it unless seeing it I guess

=lookup([@Age],(0,18,40,65),{"Youngster","Adult","Mature","Senior"})

 

[DanteAmor]

It is a regular formula, you should not enter it as an array formula.

Maybe you need the @, then

=LOOKUP([@Age],{0,18,40,65},{"Youngster","Adult","Mature","Senior"})

Or maybe you need the separated semicolon:

=LOOKUP([Age],{0;18;40;65},{"Youngster";"Adult";"Mature";"Senior"})

Or this:

=LOOKUP([@Age],{0;18;40;65},{"Youngster";"Adult";"Mature";"Senior"})

 

[toony]

It is a regular formula, you should not enter it as an array formula.

Maybe you need the @, then

=LOOKUP([@Age],{0,18,40,65},{"Youngster","Adult","Mature","Senior"})

Or maybe you need the separated semicolon:

=LOOKUP([Age],{0;18;40;65},{"Youngster";"Adult";"Mature";"Senior"})

Or this:

=LOOKUP([@Age],{0;18;40;65},{"Youngster";"Adult";"Mature";"Senior"})

Do you press control+shift+enter for the curl brackets or manually entered?

 

[DanteAmor]

Manually.
In this case, they are used for a data array.
But it is not a formula array.

 

[toony]

Do you press control+shift+enter for the curl brackets or manually entered?

Thanks it works perfect too. I put the semicolon just after I sent you the reply and put the curl bracket manually again and it's fine. I must have missed one thing or another. Cheers