Formula to ascertain a rating from multiple scenarios - urgent - help please !!
Posted on 2013-06-19
Here's one im hoping you can help me with:-
I have two tables of information that have an impact on ascertaining a certain rating based on the results.
First a category is selected in cell A1 that is either 1,2,3 or 4
Basically here are the two tables:-
0 - 3 = N/A
3 - 10 = low
10 - 30 = medium
30 - 100 = high
0% - 60% = n/a
60% - 90% = low
90% - 99% = medium
99% - 100% = high
The ratings table is as follows:-
Category 0 1 2 2 3 3 4
n/a n/a low medium low medium high
Low a n/a a b b c n/a
Medium b n/a b c c d n/a
High n/a c c d d d e
What I want is if category 3 is selected in cell A1, and cell B1 totalled to 5 and cell B2 was 66% then cell B3 would look up the results criteris from table 1 and table 2 and based on the results would return a rating of 'b'.
Can you help as Im desperate and im sure this would be a challenge for you mega experts
Many Thanks in advance for your help