View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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