I have a range in excel sheet where there are 5 possible choices to make. they all have a value in percentage. If the user will put an X in "never" it will have value of 0%, if they user puts X in "sometimes", it has a value of 6.25%
There are 5 questions where the user can put a X depending on the answer she/he will give.
these are the values I have added:
Never = 0%
Sometimes = 6.25%
Often = 12.5%
Mostly = 18.75%
Always = 25%
I a user would have chosen like this:
(range N3) question 1= Never
(range O3) question 2 = sometimes
(range P3) question 3 =sometimes
(range Q3) question 4 =often
(range R3) question 5 =mostly
I should get the total in the values 43.75%
Any idea how to solve this would be really great.