Formula for Reversing Score items

[Guest]

I am having trouble with a formula to reverse score items to responses in a
survey. I.E. Participants mark scores from 1 to 5. There are a few items
where I want the scores to be reversed, ie 1=5, 2=4, etc. How do I do
this??????HELP

 

[Carim]

Hi Amanda,

=5+1-A1 should do it ...

HTH
Cheers
Carim

 

[Guest]

Hi Carim,
Thanks for your reply.
I tried your suggestion and I had also previously tried =6-A1, but a message
comes back that it's a circular reference. I need more help please.

 

[Carim]

Amanda,

For the test, make sure your numbers are in column A - with nor
formulas -,
and in Column B type your formula ...

HTH
Cheers
Carim

 

[Guest]

I have done that too, but it computes the corrected score in the B column.
I'm doing something very simple wrong I know, but it's frustrating me.

 

[Guest]

You will now have to copy/paste special ==>values from column B to Column A
for the "reversed" results.

In Excel, a cell can contain a value OR a formula so as Carim advised, you
have to use column B to get your required results: you cannot use column A as
you get the circular reference error.

HTH

 

[Gord Dibben]

Amanda

One method.

=LOOKUP(A1,{1,2,3,4,5},{5,4,3,2,1})

Drag/copy across and down to get your new matrix as a reverse of the current
one.


Gord Dibben MS Excel MVP

I am having trouble with a formula to reverse score items to responses in a
survey. I.E. Participants mark scores from 1 to 5. There are a few items
where I want the scores to be reversed, ie 1=5, 2=4, etc. How do I do
this??????HELP

Gord Dibben MS Excel MVP

 

[Guest]

You have all helped. From everything you have all helped me with I have
compiled something. THANKYOU