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
--
Amanda

Hi Amanda,

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

HTH
Cheers
Carim

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.
--
Amanda


"Carim" wrote:

Hi Amanda,

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

HTH
Cheers
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

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.
--
Amanda


"Carim" wrote:

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

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

"amanda" wrote:

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.
--
Amanda


"Carim" wrote:

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

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

On Sat, 2 Sep 2006 00:12:01 -0700, amanda
wrote:

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

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


"Gord Dibben" wrote:

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

On Sat, 2 Sep 2006 00:12:01 -0700, amanda
wrote:

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