Golf Formula

  • Thread starter Thread starter aussiemike
  • Start date Start date
A

aussiemike

Are there any golfers out there who may know the formula I would enter
to establish stableford points from strokes entered??
Regards from Kenya
Aussiemike
 
If F2 contains the score and G2 contains par for that hole, then
=IF(F2=0,0,MAX(G2-F2+2,0)) will give a Stableford score as per:

score par stableford
0 5 0
9 5 0
8 5 0
7 5 0
6 5 1
5 5 2
4 5 3
3 5 4
2 5 5
1 5 6
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Information results on user form? 2
Need help with a function for a golf match spreadsheet 1
Excel Formula's 8
Golf Handicap Using Last 5 Scores 5
Help with LOOKUP (golf handicaps) 20
offset example wanted 1
Selecting values from a single table 1
Index function to find nth occurrence 4

Back
Top