Comment card percentage formulas
If you want a simple % then
For "Excellent" Customer service =30/39 as a %
"chicpea" wrote:
Hello,
I hope that someone here can help me. I cannot remember a formula for
a comment card tracking system.
Basically, I have created the following form to track guest comment
cards and want to come up with a satisfaction rating in percentage
form.
Excellent Good Fair
Poor Satisfaction Rating
Customer Service 30 8 1
Meals 27 10 1
Menu 22 14 3
Atmosphere 33 5
Thank you in advance for any assistance you can provide
|