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

's Computer Specifications

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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Organizing rating scale information into a narrative paragraph	Noj	Microsoft Excel New Users	1	8th Mar 2010 02:29 PM
Applying a rating scale to numerical measurements	=?Utf-8?B?R2VvcmdpYUs=?=	Microsoft Excel Misc	3	2nd Nov 2007 01:37 PM
Can a CPU's FSB rating exceed the MOBO's FSB rating and still operate?	blargg27@gmail.com	Computer Hardware	4	21st Oct 2005 12:16 AM
Auto rating a client with collected points base a Rating table	Simon	Microsoft Access Queries	4	28th Feb 2005 09:59 PM
Auto rating a client with collected points base in a rating table	Simon W	Microsoft Access Form Coding	2	8th Nov 2004 09:45 PM