If statements with values assigned depending on intervals (nested if-statement)

[nrc_me1]

Dear All,

I am trying to get a couple of if statements based on intervals (greater than/equal to) to work and I do not understand where the mistake is. Please see file attached.

Could you kindly help me?

Many thanks!

test.xlsx (42.8 KB)

[Kal_Lam]

@nrc_me1, you could do this through a single if-statement which we call a nested if-statement as shown in the image shared below:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo: when 0 is entered

Data entry screen as seen in Enketo: when 1 is entered

Data entry screen as seen in Enketo: when 2 is entered

Data entry screen as seen in Enketo: when 3 is entered

Data entry screen as seen in Enketo: when 4 is entered

Reference xlsform:

Test.xlsx (8.7 KB)

[nrc_me1]

@Kal_Lam , Great! it worked!

Thanks a lot for your support.

Francesco