Hello,
Quick and simple question. I have a questionnaire with many categories/sections and each category have one, ten or more questions in it.
The answers are yes or no and they have to put an X on the corresponding column
what is the formula to count
if all of the question yes = green
70% to 80% of the questions yes = yellow and
below 70% of the questions yes= red
Thanks
Alex
Quick and simple question. I have a questionnaire with many categories/sections and each category have one, ten or more questions in it.
The answers are yes or no and they have to put an X on the corresponding column
what is the formula to count
if all of the question yes = green
70% to 80% of the questions yes = yellow and
below 70% of the questions yes= red
Thanks
Alex