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 Expand viewCollapse view
`=IF(F4>30;0;1),`

=IF(AND(F4>=31;F4<=60;0;1))

=IF(F4<61;0;1)

I need to merge it when one cell is "true" to convert it to a logical function to display the age range according to the above three categories.

Thank you