How to use IF conditional statement with multiple choice

[Kal_Lam]

@summerywy, these posts discussed previously should help you answer your query:

Calculate using IF Formula with Multiple Expression (composite index/weighted score)

Well if this is your requirement, you could design your survey project using the following if-statement 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 screen as seen in Enketo: If option 1 is selected, the system gives a score of 3 [Output 1] Data entry screen as seen in Enketo: If option 3 or option 2 is selected with 1, the system gives a score of 3 [Output 2.1] Data entry screen as seen …

… this too …

Fomula for finding BMI

@hhfoffice, you could do it by adding an if-statement as shown in the image below: In the survey tab of your XLSForm: [Image 1] Data entry screen as seen in Enketo: [Image 2] Reference XLSForm: Calculate BMI.xlsx (9.2 KB)

… and this too …

How to score different percentage ranges from an integer input value

Maybe you could do it as outlined in the image shared below: In the survey tab of your xlsform: [Image 0] Data entry screen as seen in Enketo: [image] Data entry screen as seen in Enketo: [image] Reference xlsform (edited): BSA-V1.xlsx (10.4 KB)

… and this too …

How to build an eligibility criteria from the weight assigned to certain conditions (composite index)

OK, here is the revised one. This should work as you outline: In the survey tab of your xlsform: [Image 1] In the choices tab of your xlsform: [Image 2] Data entry screen as seen in Enketo: when conditions are not met [Image 2.5] Data entry screen as seen in Enketo: when conditions are not met [Image 3] Data entry screen as seen in Enketo: when conditions are not met [Image 4] Data entry screen as seen in Enketo: when conditions are met [Image 5] Reference xlsform: Eligibility Cr…