Hi all
I am building a a scorecard based on rating i am however finding it dificult to find the inbetween rating see table below.
% achieved 0% 90% 100% 102% 105%
Rating 1 2 3 4 5
So the idea is if you achieve 50% what would be the rating between 1 & 2 example 1.2 or 1.3 etc. i know i can create a list in the back end but to what extent.
Any idease on this please?
ZainO
In this example of 50% the result would beFormula:
=SUM(0.5*SUM(0.9/1))+SUM(2-1)
However, you need to work out the ratio or decimal number for each band as you have different parameters for each rating, eg. .9 between 1 and 2, .1 between 2 and 3
The idea of rating such as you've done is to count the number within a band as opposed to what you're asking for though
Last edited by PFDave; 11-11-2016 at 04:53 AM.
Hi
Try this in J2 (you can copy down)
Formula:=FORECAST(I2,OFFSET(B$3:C$3,0,MATCH(I2,B$2:F$2,1)-1),OFFSET(B$2:C$2,0,MATCH(I2,B$2:F$2,1)-1))
where
B2:G3 has values {0\0.9\1\1.02\1.05\5;1\2\3\4\5\5}
I2 has % achieved
See the file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks