Ok... please look at the following using the 'Courier' font:

KPIs | Rating scale | Entered |
Rating
| | value |
eqivalent

+----+----+----+----+----+----+----+----+----+----+
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
------+----+----+----+----+----+----+----+----+----+----+---------+----------+
KPI 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |
|
KPI 2 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 99 | |
|
KPI 3 | 0 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | |
|
------+----+----+----+----+----+----+----+----+----+----+---------+----------+


I enter a value for a KPI in the 'entered value' cell. Then,
automatically, the rated equivalent appears in te 'Rating equivalent'
cell.

eg: For KPI 3, I enter '15'. The rating equivalent should be '4'.


Any help would be greatly appreciated.


--
keysersoze