Survey Results- Word needs to be changed to number to quantify

Kristin Pereira

Good morning,

I am currently working on a survey where the questions used words instead of numbers. I need to change the results from the words to a numerical value.

Example: Excellent= 5, Good=4, Fair= 3, Poor= 2, Very Poor = 1

Thank you!

Heather Duff

Hi Kristin,

I would suggest you use a helper column for each survey question. Next to each question's column, enter the following:

=if(Q1@row="Excellent",5,if(Q1@row="Good",4,if(Q1@row="Fair",3,if(Q1@row="Poor",2,if(Q1@row="Very Poor",1,"")))))

(Where Q1 is the name of my question column.)

Hope this helps!

Best,

Heather

HILDA KOSOVICH

@Heather D This is how I did it, is this correct?