G
Guest
Hi there, i'm currently setting up a questionnaire within which i want to
assign a skin type dependant on the answers to specific questions.
Basically the way i want it to work is to assign values per question to give
a SUM at the end eg 21.
Then i want excel to look up 21 in a table and see that if the value falls
between 20 and 25 then a value of 2 is assigned to skin type. Or if the value
is between 26-35, a value of 3 is assigned etc etc
Which command is used to do this?
assign a skin type dependant on the answers to specific questions.
Basically the way i want it to work is to assign values per question to give
a SUM at the end eg 21.
Then i want excel to look up 21 in a table and see that if the value falls
between 20 and 25 then a value of 2 is assigned to skin type. Or if the value
is between 26-35, a value of 3 is assigned etc etc
Which command is used to do this?