Reverse Coding a Likert Scale in Excel

This video demonstrates how to reverse code Likert scale scores using Microsoft Excel. An IF function is used with INDEX and MATCH functions to reverse code values when specified.

[@chaplainjerry]

The easiest way to reverse any scale is to subtract by Q+1, so for a seven point scale the formula would be =8- B2

[@gy3041]

Great idea!

[@Kitkat915e]

Thank you so much for this, just saved me a lot of extra work lmao

[@anitacarvalho6270]

thanks!

[@Binkoro]

OMG! That is so simple and it works! Thank you!

[@katrinajoyescanela3482]

thank you!!!

[@chaplainjerry]

The easiest way to reverse any scale is to subtract by Q+1, so for a seven point scale the formula would be =8- B2

[@nataliabanasik-jemielniak9702]

omg that's brilliant!

[@natecrow21]

Hi Todd. Thanks for the video. This is the walk-through I needed. I'm still a little stuck. I'm linking data from two Google sheets.If I sent you my spreadsheet can you give me some feedback about the stuck point?

[@Maria-wg3yu]

Saved my life! Thank you

[@mccarronjr]

Hi Todd, could you put up a link to a template of this??

[@hipeace85]

Thank youuuu so much! This was so helpful, I was breaking my head trying to process the input from FFMQ (Five Facet Mindfulness Questionnare) and this made it like a breeze. So happy :))

[@genggetastic1259]

Super helpful sir.
Salute from Indonesia 🇮🇩.

[@asitpurohit]

Hello Todd, I need little help, how to use this formula for whole sheet when data is distributed horizontally...

[@nataliabanasik-jemielniak9702]

very cool, thank you!

[@matt-n-andreadzak3975]

Here's a scoring formula: (UA-cam Tutorial=1; My Brain=0)

[@iflowmagazine]

I like this video. How do I do this with 69 questions of a 7 point likert scale? I would like to then analyze in IBM SPSS. Please and thank you.

[@angiegrimes7265]

I found thi video to be very educational. I was wondering how you would score this scale when you had reversed the questions. So thanks.

[@monicaperry13]

Having just read about Likert scale, I found this video to help me both remember that particular scale as well as learn more about how excel works. I found it interesting how the numbers could easily be reversed.

[@amgc2009]

Hi, This was super helpful! The problem I have is that for items that are 0 and reversed scored (0->2), the excel file automatically inputs a 2 even when there's no 0 entered (just a blank box). Is there a way to fix that? Thanks so much!

[@boering2sticks]

What does "pressing function for" (??) at 6:33 means?
Thanks for answers!

[@DrGrande]

The F4 key (function four key) on the top of the keyboard will change a relative reference to an absolute reference.

[@boering2sticks]

Haha, funny misunderstanding! Thanks a lot!

[@gnosetech5381]

there is an eazy way to do the same work :
=if(C2="R";(max-B2)+min;score) // where min=1 and max=5 for Likert 5Pts
great work thanx !

[@melanietarr1971]

Hi,
I'm also looking for the easier way.
Thank you so much

[@matthewstaheli]

Just make a new column and enter a formula for 6 - whatever number needs to be reverse coded (for a 5 point scale). 7 - whatever number needs to be recoded (for a 6 point scale).

[@bellamaria2582]

Matt S. Hero, thank you!

[@khalidjarrar3256]

can we apply this for 4 point scale !?

[@chaplainjerry]

5-B2