Convert likert scale numbers to percentages

B

BW@Intuit

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
 
Top