Convert likert scale numbers to percentages

G

Guest

Is there a formula that will convert my likert scale numbers to percentages? For example, 1=100%, 2=75%, 3=50%, 4=25%, and 5=0%. So, if I have a 2.5, what % is that?
 
F

Frank Kabel

Hi
try
=1-((A1-1)/4)
where A1 stores your scale number. Format the resulting cell as
percentage
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top