Reverse Scoring in Sheets/Excel

[@OMU215]

This is very helpful. Thank you so much🤍

[@kathajain9397]

Hi..that would be so handy but could you please explain about the normal scoring as well..recently heard it from a friend to not use find and replace option.

[@motherofturtles3297]

Hi, I'm not quite sure what you are asking. Are you asking how to code text responses into numbers? If so, in Sheets you should create a new column and then use an IF statement to automate the coding process. Hope that helps!

[@kathajain9397]

@@motherofturtles3297 Yeah, you interpreted it right. Thanks a ton and even more for reverse scoring!!

[@motherofturtles3297]

@@kathajain9397 Excellent, and that is a great idea for another video :)

[@kathajain9397]

@@motherofturtles3297 Absolutely :))

[@nikitasundar7595]

So helpful…thank you!

[@raien00]

Thank you so much❤️❤️

[@Sigmund6]

hello my highest scoring is 4 and the result was -1 is it still okay the -1 ?

[@motherofturtles3297]

No. It sounds like your numbering is 0 to 4. If that’s the case (less common than scales starting at 1) you should just use your highest number and subtract your score from 4, so 4 reverse scored would be 0. If your scale is 1 to 4, you would use top score + 1 so it would be 5-4 and that would make your new value 1. Hope that helps!

[@Sigmund6]

@@motherofturtles3297 so lets say number is 3, number 3 does not change right? its still 3 is to 3 ?

[@motherofturtles3297]

That depends on your scale. 3 would remain 3 if your scale is 1 to 5. You should watch my video on conceptual reverse scoring.

[@isabel9angulo]

THANK YOU!