Complex Skip Pattern Errors (case 21014)
Complex Skip Pattern Errors (case 21014)
Hi,
I am trying to develop a complex skip pattern for a psychopathology interview. All questions are answered yes or no and based on the responses or the number of responses in a specific section, the interview will go in different directions.
I have created simple skips directly in medialab (i.e. If 1a is yes, skip to question 2, if 1a is no, go to 1b). I have now created a responses.xls file for complex skips and I am trying to figure out the appropriate formula.
Section A is divided into two parts. The first part has 8 questions. If none of the questions have a yes answer, the participant is taken directly to section B. If any of the 8 questions are answered yes, the participant continues on to the next question in section A. Medialab exports no answers as a 1 and yes's as a 2 into excel so I created the formula:
=IF(SUM(A5:A12)>8,"ADHDa05","ADHDb1a")
With cell A5 being the first question in section A and cell A12 being the 8th. ADHDa05 is the variable name for the second half of section A and ADHDb1a is the 1st variable in section B.
When I run medialab, if all questions are answered no, it responds appropriately and if all answers are yes, it responds appropriately. However, if there is a combination of yes's and no's, medialab skips the rest of Section A while those questions actually need to be asked.
What are the formulas in the responses.xls file like this supposed to do?
=IF(AND(A5=1, A6=1, A7=1, A8=1, A9=1, A10=1, A11=1, A12=1), A20, A13)
The variables in cells A5 through A12 are Yes/No questions. If the participant answers "No" to all 8 questions, there should be a skip to Cell A20, but if 1 or more questions in A5-A12 are answered "Yes," the questionnaire should continue to cell A13.
If you would like, please send me copies of your files and I will be happy to take a look. You can upload them here or send them to support@empirisoft.com; please reference case 22104 in the email.
