I am trying to code multiple responses as correct in my builder experiment. I have a column on excel that states either 3 or 6 as a potential correct answer (corrAns). What I want to do is add a code that states that the corrAns in the excel column, but also the corrAns - 1 (so 2 or 5 would also be classified as correct depending on whether the corrAns in the column is 3 or 6) and also the corrAns - 2 (so 1 or 4 would also be classified as correct, again depending on whether the corrAns in the column is 3 or 6) should be classified as ‘1’ and any other answer is classified as 0. For example, if the corrAns is 6, and a participant responds with 4, that answer should still be categorized as correct on the excel data output (it should say ‘1’ in the column and not '0).
I know that in builder you cannot record multiple answers as correct, as originally I tried to put the responses of 1,2,3 or 4,5,6 as correct answers in the excel column, and it would still categorize every answer as 0/incorrect.
What should the code look like? I only want to categorize corrAns, corrAns-1,corrAns-2 as ‘1’ and incorrect as ‘0’, rather than the data output categorizing every response as ‘0’.