[SOLVED] error #NAME?

[max_max]

Hello,
I'm trying a formula like this:

= IF (B2 <18, "Young", IF (AND (B2> 18, B2 <65), "Mature"; "Elder"))

why continue to leave in C2 (where the formula is entered) # NAME? if I write any number in B2?
max_max

[Miraun]

Hi Maxmax, two things:
I'm not sure if you spaced out the equation just for ease of reading, but if it's actually written like that, Excel doesn't like spaces too much. But other than that, the ; after "Mature" needs to be a ,

There may be some localization with the Italian version of Excel that I'm unaware of, but let me know if that does the trick.

[jeffreybrown]

There seems to be nothing wrong with the structure of the formula.

What is the ; for?

If your version used the ; then it should be in place of all the , or use all ,.

What happens when you change "Mature","Elder"

[L-Drr]

Not what you asked for, but people of exactly 18 years old will be called Elders in your formula

[shg]

= lookup(b2, {0,18,65}, {"Young","Mature","Elder"})

[max_max]

Excuse me,
I found the error: I did copy / paste wrong:
= IF (B2 <18, "Young", IF (AND (B2> 18, B2 <65), "Mature"; "Elder"))
the symbol " included in the formula in the sheet was not accurate.
max_max

[max_max]

In Italian this formula:

= lookup(b2, {0,18,65}, {"Young","Mature","Elder"})

should be:

= Lookup(b2;{0;18;65};{"Young";"Mature";"Elder"})

but does not work.
max_max

[Tony Valko]

Your age levels are not well defined.

If B2 = 18 what result do you expect?
If B2 = 65 what result do you expect?

[max_max]

If B2 = 18 = young
If B2 = 65 = elder

[Tony Valko]

Try this...

=IF(COUNT(B2),IF(B2>=65,"Elder",IF(B2>18,"Mature","Young")),"")

Replace the commas with semi-colons if needed.

[max_max]

Formula Tony Valko translated into Italian:

=SE(CONTA.NUMERI(B2);SE(B2>=65;"Anziano";SE(B2>18;"Maturo";"Giovane"));"")

thank you
max_max

[Tony Valko]

You're welcome. Thanks for the feedback!

[max_max]

Hello to all,
SGH formula:

= Lookup (b2, {0,18,65}, {"Young", "Mature", "Elder"})

translated into Italian:

= CERCA(B2;{0;18;65};{"Young";"Mature";"Elder"})

Thanks to all from Italy
max_max

[martindwilson]

= CERCA(B2;{0;19;65};{"Young";"Mature";"Elder"}) if 18=young

[max_max]

thanks martin