• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Survey Calculation

aamirsq

Member
i want to calculate the survey result based on my data.
 

Attachments

  • survey calculation.xlsx
    8.8 KB · Views: 6
works great and what if i want to increase (decrease) the number of question or number of choices (4 to 6) ?
 
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
 
Back
Top