Golf Formula

[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

[[email protected]]

See
http://www.wiredbox.net/Forum/Thread91233.aspx

[Gary''s Student]

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

--
Gary's Student


"aussiemike" wrote:

>
> 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
>
>
> --
> aussiemike
> ------------------------------------------------------------------------
> aussiemike's Profile: http://www.excelforum.com/member.php...o&userid=34653
> View this thread: http://www.excelforum.com/showthread...hreadid=544186
>
>