How to calculate for exact age

[imk_consult]

Please help me on how to calculate for age groups as shown below.

I want in a way when you enter the exact age then it gives you the age groups in note form.

I have attached an excel file.

(Eg. Exact age 25 Age groups will be 25-29).

AGE.xlsx (9.1 KB)

Best regards

Jeremiah.

[Kal_Lam]

Welcome back to the community, @imk_consult! You could do this by following this post discussed previously:

Automatic selection of one answer based on another

In this case you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry as seen in Enketo: condition that meets the first criteria [Output 1] Data entry as seen in Enketo: condition that meets the second criteria [Output 2] Data entry as seen in Enketo: condition that meets the third criteria [Output 3] Data entry as seen in Enketo: condition that meets the fourth criteria [Outp…