help find missing paranthesis ---- please

J

jenn

=IF(AND(D2>=0,D2<=17),"Child"(AND(D2>=18,D2<=20),"Transition",IF(AND(D2>=21,D2<=59),"adult",IF(AND(D2>=60)"Older_Adult")


I am just beginning nested if's...

I'm trying to look at the Age in D2 (will fill down) and if it is between a
range then I want to give it a description (in E2)...

thanks
 
A

Alan

=IF(AND(D2>=0,D2<=17),"Child",IF(AND(D2>=18,D2<=20),"Transition",IF(AND(D2>=21,D2<=59),"Adult",IF(AND(D2>=60),"Older_Adult"))))
One shorter way would be
=IF(D2>59,"Older
Adult",IF(D2>20,"Adult",IF(D2>17,"Transition",IF(D2>0,"Child",""))))
Regards,
Alan.
 
A

Alan

That's
=IF(D2>59,"Older_Adult",IF(D2>20,"Adult",IF(D2>17,"Transition",IF(D2>0,"Child",""))))
Don't know why it text wrapped,
Regards,
Alan.
 
T

Teethless mama

=IF(AND(D2>=0,D2<=17),"Child",IF(AND(D2>=18,D2<=20),"Transition",IF(AND(D2>=21,D2<=59),"adult","Older_Adult"))
 
Top