I have a course evaluation, I want to know how i can write a formula to score the drop down. I.E. Strongly Agree =2 agree =1 neither = 0 disagree = -1 strongly disagree = -2.
I would assume a countif would do it i just don't know how to write it. and i an guessing i would have to add those together and /10 to get the percentage.
Help Article Resources
Check out the Formula Handbook template!