Hello. I'm trying to make it so that if a certain three scale response items are all answered incorrectly, it will skip to the end of the survey, but if at least one is answered correctly, it will continue on to the next set of questions.
I created a responses.xls file and put it in the same folder as the questionnaire. I see from the data files that a question answered incorrectly gets a value of 1, so I created a variable Atotal that is the sum of lnsA3, lnsA6, and lnsA9 (the three questions), and I set the skip to on lnsA9 (the third question) to =IF(B5=3,"end","lnsB1"). B5 is the value column for the Atotal variable I created and lnsB1 is the item I want it to move on to if at least one of the previous questions is answered correctly.
When I run the questionnaire and give three incorrect answers, it still moves on to the next question and doesn't skip to the end like it should.
What am I doing wrong here? I'm attaching the responses file and a simplified version of the questionnaire.
Thank you!