i want to calculate the survey result based on my data.
aamirsq Member Jan 19, 2015 #1 i want to calculate the survey result based on my data. Attachments survey calculation.xlsx 8.8 KB · Views: 6
N NARAYANK991 Excel Ninja Jan 19, 2015 #2 Hi Aamir , See if this is acceptable. Narayan Attachments survey calculation1.xlsx 9.3 KB · Views: 15
aamirsq Member Jan 19, 2015 #3 works great and what if i want to increase (decrease) the number of question or number of choices (4 to 6) ?
works great and what if i want to increase (decrease) the number of question or number of choices (4 to 6) ?
N NARAYANK991 Excel Ninja Jan 19, 2015 #4 Hi Aamir , Just be sure to insert the weightages for each question in the column K , and the weightages for each answer in the cells C1 through F1. Also , the formula will have to be modified to include the increased number of questions and answer options. Narayan
Hi Aamir , Just be sure to insert the weightages for each question in the column K , and the weightages for each answer in the cells C1 through F1. Also , the formula will have to be modified to include the increased number of questions and answer options. Narayan