I've found a lot of good help here before so I'm turning towards you with this problem that i can't find a fitting solution to.
Im working to summarise data from a survey done with google forms and have asked the respondents a series of questions that was meant to be exclusive so if they answered "no" Q1 they wouldn't answer "yes" to Q2. It turned out my questions wasn't that good formulated so now i need your help to figure out who has answered "yes" followed by "yes" on the next question in a series of four total. Each questions is in a separate column so what i want to do is make excel give output 4 if respondent has answered "yes" consequently on all four questions, i.e "b2=1 and c2=1 and d2= 1 and e2=1), and grading downwards with 0 if respondent answered 0 to Q1.
=if(b2=1(AND;c2=1(AND;d2=1(AND;e2=1;[1];[0])[0])[0])[0])
Aucun commentaire:
Enregistrer un commentaire