Jul 30 2021 02:27 PM
Aug 01 2021 08:11 AM
I don't know if others know what you mean by "reverse score"--I googled the term in order to learn, even found a YouTube video with one solution. https://www.youtube.com/watch?v=_oeP7gdCKLs
That video contains a solution with nested IF statements that I found a bit clunky, frankly. So IF that's the formula you know, I have a suggestion for a better way...but why don't you help me (and others) help you by giving a more complete description here?
Personally, if you just want a suggestion or two, I think I would avoid the nested IFs in favor of either
In any event, I don't think there's an "automatic" wand you can wave, somehow avoiding a formula or function of some kind.
Jun 25 2022 10:09 AM
Hi @Jayqwellen ,
Sorry I'm a little late to the party but thought I'd chime in since others may encounter a similar problem.
I managed a quick-fix reverse score on a four-point Likert scale over 10 columns of 5000+ rows by:
Note I didn't just replace 1 with 4 off the bat since this would have conflated my newly-reversed 4s with my existing 4s, and the same for my newly-reversed 3s. Using 10s, 20s etc provided a quick code to sidestep this problem.