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!
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!