G Guest Feb 3, 2004 #1 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?
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 Feb 3, 2004 #2 Hi try =1-((A1-1)/4) where A1 stores your scale number. Format the resulting cell as percentage Frank
Hi try =1-((A1-1)/4) where A1 stores your scale number. Format the resulting cell as percentage Frank
