Calclulating the number in the midle

[ZainO]

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

[PFDave]

In this example of 50% the result would be

Please Login or Register  to view this content.

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

[José Augusto]

Hi
Try this in J2 (you can copy down)

Please Login or Register  to view this content.

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