Hi everyone,
I'd appreciate some help putting together a formula for my golf club scoring sheet. I've used this forum before and the help was magnificent. I'll first outline how the scoring works, and then explain the spreadsheet.
The format is called "Stableford", and rather than putting down the amount of strokes you hit on a hole, each hole is allocated points, based on it's difficulty, and the ability of the golfer.
Golf handicaps range from 0-36. Depending on the difficulty of a hole (the index), and ability of the golfer, they are allocated "shots" on each hole. The index ranges from 1 as the most difficult hole, through to 18 as the least difficult. For example, if i had a handicap of 9, I would be allocated a "shot" for each of the 9 hardest holes, and no "shots" for the 9 easiest (nb: The Par column has no bearing. I just added it to be consistent with my spreadsheet)
HOLE - PAR - INDEX - SHOTS
1 - 4 - 13 - 0
2 - 4 - 7 - 1
3 - 4 - 5 - 1
4 - 5 - 10 - 0
If my handicap was 18, i would get a shot on every hole. If my handicap was 27, I would get a shot on all 18, and then an extra shot on the 9 hardest
HOLE - PAR - INDEX - SHOTS
1 4 13 1
2 4 7 2
3 4 5 2
4 5 10 1
What i am looking to do with the spreadsheet in Column E is calculate the shots for ALLEN, based on the Index of the hole (column D), and the handicap (cell M1). That is a handicap 18 or less. For Allen, he gets a shot on the 9 hardest holes. I think i have that, as i put =IF(D5<=M1,1,0) and it appeared to work. However...
I also need to calculate those that have a handicap 19-36, so, in Column E, calculate the shots for BELL (column E), based on the Index of the hole (column D), and the handicap (cell M20). For Bell, he gets one shot for each hole, and get two shots for the 9 hardest holes.
Hopefully that makes sense
Cheers
Damian
NB: I have also posted this in another forum, in the event no one is able to assist. As per the rules, here is the link mrexcel.com/board/threads/golf-scoring-formula-possibly-if-statement.1150326
Bookmarks