Compute a rating of a mtd average compared to a rating scale

R

reddy

I have a monthly number of complaints. I need to compute a MTD average of
these complaints and rate them as excellent, good, fair. The problem is that
the rating scale changes based on the month

Month Complaints Excellent Good Fair
Jan 2008 20 <=20 21 - 30 >30
Feb 2008 30 <=20 21 - 30 >30
Mar 2008 40 <=10 11 - 25 >26
Apr 2008 <=10 11 - 25 >26
May 2008 <=10 11 - 25 >26

I need to compute a MTD Rating of complaints only for those months that have
complaints recorded -in this case Jan-Mar 2008 (data for Apr onwards is not
yet available). I require this formula to be in one cell (hopefully).

Please help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MTD Rating 1
Countifs or a pivot 1
Adding Filtering to a Rating Equation? 0
How to avergage colums 7
Finding the week of date 4
YTD budget based on current input of actual 4
Applying a rating scale to numerical measurements 3
Find the position of a date 6

Top