how do I recode a likert scale

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

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

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

In article <4EA04644-0A69-4370-97AC-A9BA9C44BB25@microsoft.com>,
merlin@discussions.microsoft.com says...
> how do I recode the negatively coded questions on a likert scale?
>
> where 0=4, 1=3, 3=1, 4=0
>
>
>
>

Thank you Tushar

"merlin" wrote:

> how do I recode the negatively coded questions on a likert scale?
>
> where 0=4, 1=3, 3=1, 4=0
>
>
>

You are welcome.

--
Regards,

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

In article <2301430E-D56E-4BA2-A298-9B6ADA95898F@microsoft.com>,
merlin@discussions.microsoft.com says...
> Thank you Tushar
>
{snip}