I wish to reduce a ranking based on points scored

[AmbroseCP]

If a player scores 39 points off a 10 handicap, (>38) his handicap must be reduced by 1 (to 9) If he scores 40 points, his handicap must reduce by 2 (to 8)

Can you please assist?

I can get the IF function to work for only 1 deduction in handicap but I would like it to deduct progressively.

39 points -1
40 points - 2
41 points -3, etc

=IF(D2>38,E2-1,E2)

39 10 9

[zbor]

Try

=38-A1

[AmbroseCP]

No Name Surname Jan HC Feb HC
1 Tony Voges 39 10 9

[AmbroseCP]

Thanks zbor but I think you are misunderstanding my question.

A golf has a handicap: 10
He scores 39 points in a round of golf.
I would like to reduce his handicap to 9
If he scores 40 points in a round, I want to reduce his handicap to 8. etc
39 points = minus 1 off his 10 handicap
40 points = minus 2 off his handicap.... ETC