How to define a range of values while writing IF condition in Excel?

Question

I am trying to write a NestedIF to sort out if people are Young, Middle aged or Old. now I want to get "Middle Aged" for all the values between 25 to 65.

Answer 1

Try this

=IF(A1<25,"Young",IF(AND(A1>=25,A1<=65),"Middle Aged","Old"))