I need to advise on how to use the logical function in the table where I have to break down employees by age category:
first category - up to 30 years old
second category from 31 to 60 years old
third category over 60 years
so far I have only used the "IF"
Code: Select all
=IF(F4>30;0;1),
=IF(AND(F4>=31;F4<=60;0;1))
=IF(F4<61;0;1)
Thank you