Hi there.
I have an 18 question tool with a 5 point likert response scale (1 = Strongly disagree 2 = Disagree 3 = Undecided 4 = Agree 5 = Strongly agree).
I would like to calculate a total score for each respondent but have 8 questions where these need to be reverse scored. So items 1, 2, 5, 6, 7, 8, 17, and 18 should be reverse scored as follows: (1=5) (2=4) (3=3) (4=2) (5=1).
I have tried this for the reverse scored questions
if(${Q1}=‘Strongly disagree’,5,0)+if(${Q1}=‘Disagree’,4,0)+if(${Q1}=‘Undecided’,3,0)+if(${Q1}=‘Agree’,2,0)+if(${Q1}=‘Strongly agree’,1,0)
And this for the others
if(${Q3}=‘Strongly disagree’,1,0)+if(${Q1}=‘Disagree’,2,0)+if(${Q1}=‘Undecided’,3,0)+if(${Q1}=‘Agree’,4,0)+if(${Q1}=‘Strongly agree’,5,0)
But I keep getting an error message that the “parser is broken”
I would appreciate some help with the expressions for the calculation.
Many thanks,
Alice