Hello,

I would like to record data in Excel, i.e., making 5 become 1,
making 4 become 2, making 2 become 4, making 1 become 5, to change the
direction of negative-worded item questions.

Might anyone know how to accomplish this task in Excel?

I know SPSS can do this. But I need to record the data in Excel
in order to do other tasks.

Thank you very much and look forward to your kind reply.

Please take care

Caroline

See your other post - try this formula:

=6-A1

if your number is in A1. Copy down as necessary.

Pete

On Mar 27, 1:18 am, "zencaroline" <zencarol...@gmail.com> wrote:
> Hello,
>
> I would like to record data in Excel, i.e., making 5 become 1,
> making 4 become 2, making 2 become 4, making 1 become 5, to change the
> direction of negative-worded item questions.
>
> Might anyone know how to accomplish this task in Excel?
>
> I know SPSS can do this. But I need to record the data in Excel
> in order to do other tasks.
>
> Thank you very much and look forward to your kind reply.
>
> Please take care
>
> Caroline