Golf Handicap Adjustment Formula

[ahurt]

Hello all,

I am attempting to build a spreadsheet for my 9 hole golf league that will calculate adjusted scores for handicaps. I currently have a working function for when only one stroke needs to deducted from a hole - but I cannot figure out how to create a similar function for when two strokes need to deducted. Any help would be appreciated.

Here is the working function for a single stroke:

=IF(C22<=2*$B$25,C5-1,C5)

=IF(Hole Handicap <= 2*Individual Handicap, Gross Score - 1, Gross Score)

That works when the individual handicap is 9 or smaller. But when an individual handicap is greater than 9, a players gets two strokes deducted from the hole score on the hardest holes.

I would really appreciate any help.

Thank you.

[BadlySpelledBuoy]

Could we see a sample workbook with some example scores entered manually to demonstrate this?

BSB

[MarvinP]

Hi ahurt,

I call these "Pops". Pops are the number of strokes a player gets off depending on their handicap and the hole handicap. I've had many formulas in the past and have settled on this one.

Pops = If(HHC#<=Mod(CH#,18),1,0)+Int(CH#/18)

HHC is the hole handicap. We have handicap holes 1 to 18. CH is the players Course Handicap.

This formula in words is: If the hole handicap is less than or equal to the MOD of the players Course Handicap, 18) then 1 else zero and add to this the Integer part of the players CH / 18.

I hope you can adapt this to your 9 hole course. Try some examples using real numbers and see if it works for you. You will need to change the 18 to 9, I'm assuming.