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.