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.