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


Try this

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

0

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