IF statement with multiple AND returning #NAME? error

[Pr0]

Hi all.
I'm getting a #NAME? error on this formula.

=IF($ah8 >=3; ”Infancy”;
    IF(AND($ah8 >=4; $ah8 <=11); ”Childhood”;
       IF(AND($ah8 >=12; $ah8 <=20); ”Adolescence”;
          IF(AND($ah8 >=21; $ah8 <=35); ”Early adulthood”;
             IF(AND($ah8 >=36; $ah8 <=50); ”Midlife”;
                IF(AND($ah8 >=51; $ah8 <=80); ”Mature adulthood”; ”Late adulthood”
                  )
               )
            )
         )
      )
   )

I can't figure out why. Help?

PR

[AliGW]

Possibly a silly question, but do you need to use the Portuguese versions of the function names?

[Pr0]

I don't understand what you mean... I'm using the english version.

PR

[AliGW]

I don't understand what you mean... I'm using the english version.

PR

You don't understand why I might think someone in Portugal might be using a Portuguese language version???

As has already been stated, it's the quotation marks that are incorrect. They need replacing with straight quotes: "Infancy"

[bebo021999]

I have no idea where this double quotation symbol ”Infancy” comes from, but try to replace they by "Infancy" (This is button next to Enter button) then it should work.
BTW, this formula is return "infantry" for any value in AH8 those equal or greater than 3, so try to build it again: starting from greatest value: 80

=IF(AH8>80,"Late adulthood",IF(AH8>=51,"Mature adulthood",......

[Pr0]

You don't understand why I might think someone in Portugal might be using a Portuguese language version???

As has already been stated, it's the quotation marks that are incorrect. They need replacing with straight quotes: "Infancy"

Dear AliGW, when you said in your first post - Portuguese versions of the function names, I actual thought that you meant portuguese words for IF and AND (which is a silly assumption from me, by the way) and not the quotation marks, which I honestly didn't notice weren't straight ones (and I too don't know where I got them from ). Bottom line: I've misinterpreted you.

BTW, this formula is return "infantry" for any value in AH8 those equal or greater than 3, so try to build it again: starting from greatest value: 80

=IF(AH8>80,"Late adulthood",IF(AH8>=51,"Mature adulthood",......

You're absolutely right - I meant <=3 and not >=3.
It's all good now. Thank you both.

PR

[AliGW]

I wouldn't know how a Portuguese language version handles IF and AND - that was my point. In some foreign languages, these are translated, and the error was consistent with this possibility. Please be aware for the future that members here will not know all language versions inside out (if at all)!!!