Excel Help - Should be simple for some.

[MrKeeno]

Hope you can help with this as my excelskills are severely lacking

We are introducing a bonus scheme in work for a bit of fun, hopefully to get a bit of healthy competition going between various teams. We had an old bonus system before my time and it is this they are looking to go with again. I want to use excel to calculate the bonus/points.

The target bonus needs to be easily changed, but say for instance it needs to be 96.8%

If a team gets:

Between target and +0.99% they get 4 points
Between +1% and +1.99% they get 6 points
Between +2% and +2.99% they get 9 points
Between +3% and +3.49% they get 14 points
+3.5% and above they get 16 points

Hopefully someone can help with this.

Thanks in advance.

 

[MrKeeno]

Is there any chance you could write a line of this for me and then I can duplicate it for the other targets? I honestly have no clue how to do it