View Single Post
  #1   Report Post  
andythescientist
 
Posts: n/a
Default How to assign a score, dependant on a sum falling within a range?

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?