How to record data in Excel?

[zencaroline]

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

 

[Pete_UK]

See your other post - try this formula:

=6-A1

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

Pete