Show: "children" if value in cell is between 0 to 12...

[malafaia1]

Hello, everyone.

I looked all over the internet and found no solution to this issue. I want my cell to show a text depending on the value the previous one is showing. To be precise:

Show: "children" if value in cell is between 0 to 12..., "adolescent" if value in cell is between 13 to 17 and "adult" if value is 18 or above.

So far, I know that if I do a

=IF(A1 <= 12; "Children")

it works fine, but if I try something like...

=IF(A1 <= 12; "Children", A1 <= 17; "Adolescent"; A1 >= 18; "Adult")

...it won't work. Can you guys help me out on this one? Thank you!

 

[AhoyNC]

Try:

[TABLE="width: 480"] <colgroup><col width="480"></colgroup><tbody>[TR] [TD="width: 480"]=IF(A1<=12,"Children",IF(A1<=17,"Adolescent","Adult"))[/TD] [/TR] </tbody>[/TABLE]

<colgroup><col width="480"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Welcome to the MrExcel board!

Another option would be

=LOOKUP(A1,{0,13,18},{"Children","Adolescent","Adult"})

 

[malafaia1]

Hello, everyone, and thanks for the warm welcome.

Sadly, none of the functions above worked for me (Formula parse error). Do we have any other options? Thank you!

 

[AhoyNC]

Could it be that your language setting for Excel uses a semicolon instead of a comma in its formulas?

=IF(A1<=12;"Children";IF(A1<=17;"Adolescent";"Adult"))

 

[malafaia1]

Worked great!!! Thanks, AhoyNC!

 

[AhoyNC]

You're welcome. Thanks for the feedback.
Peter's formula should also work for you (change , to ; ).