Hi All,
I'm trying to build a formula to give a weighted scoring system on a monthly turnover target. The turnover is in set brackets with points awarded for the higher the turnover.
The scoring system i want to try and achieve is as follows.
25 Points - £5,000+
20 Points - £4,000 - £4,999
15 Points - £3,000 - £3,999
10 Points - £2,000 - £2,999
5 Points - £1,000 - £1,999
0 Points - £0 - £999
What would be the best way of going about doing this?
Any help appreciated. Thanks.
Bookmarks