Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign a macro to Command Button Object | Excel Discussion (Misc queries) | |||
"Drop the lowest" in computing average | Excel Worksheet Functions | |||
sports score sheet | Excel Discussion (Misc queries) | |||
Assign values to names in a drop-down list? | Excel Discussion (Misc queries) | |||
Assign to macro missing | Excel Discussion (Misc queries) |