Reverse scoring

%3CLINGO-SUB%20id%3D%22lingo-sub-2596567%22%20slang%3D%22en-US%22%3EReverse%20scoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596567%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20Is%20there%20an%20automatic%20way%20to%20reverse%20score%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20the%20equation%20but%20it%20is%20slow%20and%20clumsy%20when%20you%20have%20multiple%20columns%20to%20reverse%20score.%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2596567%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2597267%22%20slang%3D%22en-US%22%3ERe%3A%20Reverse%20scoring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2597267%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1116816%22%20target%3D%22_blank%22%3E%40Jayqwellen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20others%20know%20what%20you%20mean%20by%20%22reverse%20score%22--I%20googled%20the%20term%20in%20order%20to%20learn%2C%20even%20found%20a%20YouTube%20video%20with%20one%20solution.%20%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_oeP7gdCKLs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D_oeP7gdCKLs%3C%2FA%3E%3C%2FP%3E%3CP%3EThat%20video%20contains%20a%20solution%20with%20nested%20IF%20statements%20that%20I%20found%20a%20bit%20clunky%2C%20frankly.%20So%20IF%20that's%20the%20formula%20you%20know%2C%20I%20have%20a%20suggestion%20for%20a%20better%20way...but%20why%20don't%20you%20help%20me%20(and%20others)%20help%20you%20by%20giving%20a%20more%20complete%20description%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EAre%20you%20working%20with%20the%20five-point%20scale%20or%20something%20else%3F%3C%2FLI%3E%3CLI%3EWhat's%20the%20equation%2Fformula%20that%20you%20know%20and%20are%20rejecting%20because%20of%20the%20volume%20of%20your%20data%3F%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPersonally%2C%20if%20you%20just%20want%20a%20suggestion%20or%20two%2C%20I%20think%20I%20would%20avoid%20the%20nested%20IFs%20in%20favor%20of%20either%3C%2FP%3E%3CUL%3E%3CLI%3Eusing%20VLOOKUP%20to%20retrieve%20the%20%22reverse%20score%22%20from%20a%20table%20(or%20one%20of%20the%20other%20methods%20of%20looking%20up%20a%20value%20and%20retrieving%20some%20other%3B%20XLOOKUP%2C%20INDEX%20%26amp%3B%20MATCH)%3C%2FLI%3E%3CLI%3Eusing%20CHOOSE%2C%20unless%20you%20need%20to%20allow%20for%200%20or%20N%2FA%2C%20in%20which%20case%20back%20to%20VLOOKUP%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20any%20event%2C%20I%20don't%20think%20there's%20an%20%22automatic%22%20wand%20you%20can%20wave%2C%20somehow%20avoiding%20a%20formula%20or%20function%20of%20some%20kind.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, Is there an automatic way to reverse score? 

I know the equation but it is slow and clumsy when you have multiple columns to reverse score.

Thanks.

1 Reply

@Jayqwellen 

 

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?

 

  1. Are you working with the five-point scale or something else?
  2. What's the equation/formula that you know and are rejecting because of the volume of your data?

 

Personally, if you just want a suggestion or two, I think I would avoid the nested IFs in favor of either

  • using VLOOKUP to retrieve the "reverse score" from a table (or one of the other methods of looking up a value and retrieving some other; XLOOKUP, INDEX & MATCH)
  • using CHOOSE, unless you need to allow for 0 or N/A, in which case back to VLOOKUP

 

In any event, I don't think there's an "automatic" wand you can wave, somehow avoiding a formula or function of some kind.

EXCEL formula is provided to reverse score items. Helpful for Likert scale reverse coded items.