Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas for survey
which functions should i be using. This survey is used to identify if
clients are high risk factors or not. I need to take certain yes and no answers and certain answers are weighted differently. Then if that number isn't a certain percentage it must be delivered with a yes or no answer. Help anyone?? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using formulas for survey
You might build a table for the yes answers which has an weight for each
question. You can build a similar table for no answers. The tables should occupy the same rows as the answers for ease of use. By that I mean if your answers are in A1:A20 your yes table could be in B1:B20 and the no table in C1:C20. Then you could do something like =SUMIF(A1:A20,"yes",B1:B20)+SUMIF(A1:A20,"no",C1:C 20) Tyro "snappl3" wrote in message ... which functions should i be using. This survey is used to identify if clients are high risk factors or not. I need to take certain yes and no answers and certain answers are weighted differently. Then if that number isn't a certain percentage it must be delivered with a yes or no answer. Help anyone?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Survey Tabulation | Excel Discussion (Misc queries) | |||
survey results | Excel Worksheet Functions | |||
survey | Excel Discussion (Misc queries) | |||
Survey Form | Excel Discussion (Misc queries) | |||
Getting a average from a survey | Excel Worksheet Functions |