Excel 2007- I have a survey that uses radio buttons (3 choices each answer) to select the answer.?
My trouble starts with assigning values to the answers (Answer 1 is 0, Answer 2 is 1, Answer 3 is 2), so that at the end of each section the total can be automatically calculated to eventually have a final total of all the sections.
My Questions
1. How to assign values to radio button selections
2. Which formula would I use to add all selected answers at the end of each section.
Background
-I have tried using CHOOSE function, however I don't have space or want any additional boxes made.
-Radio buttons are made and are in Group boxes
-Only one radio button is allowed to be selected per question.
-I was thinking that maybe SUM would work, however not sure with using the radio buttons (to create the total)
In the end when a person selects
answer 1 which is 0points for question 1,
selects answer 2 for question 2 which is 1 point and
for question 3 selects answer 3 which is 2 points.
The total sum will show 3/6 and (new cell) 50%
My trouble starts with assigning values to the answers (Answer 1 is 0, Answer 2 is 1, Answer 3 is 2), so that at the end of each section the total can be automatically calculated to eventually have a final total of all the sections.
My Questions
1. How to assign values to radio button selections
2. Which formula would I use to add all selected answers at the end of each section.
Background
-I have tried using CHOOSE function, however I don't have space or want any additional boxes made.
-Radio buttons are made and are in Group boxes
-Only one radio button is allowed to be selected per question.
-I was thinking that maybe SUM would work, however not sure with using the radio buttons (to create the total)
In the end when a person selects
answer 1 which is 0points for question 1,
selects answer 2 for question 2 which is 1 point and
for question 3 selects answer 3 which is 2 points.
The total sum will show 3/6 and (new cell) 50%
Comment