Im trying to create a variable age group with the following conditions
takes "1" when age <5
takes "2" when age>=5 and <10
takes "3" when age>=10 and <20
takes "4" when age>=20 and <30
takes "5" when age>=30
but i am not sure how to write a formula for this
Solved by F. A. in 26 mins