how do I recode a likert scale

[Guest]

how do I recode the negatively coded questions on a likert scale?

where 0=4, 1=3, 3=1, 4=0

 

[Tushar Mehta]

Use the formula =4-{cell containing original number}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

 

[Guest]

Thank you Tushar

 

[Tushar Mehta]

You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

Thank you Tushar

{snip}