+ Reply to Thread
Results 1 to 8 of 8

Golf Handicap

  1. #1
    Registered User
    Join Date
    02-10-2007
    Posts
    97

    Golf Handicap

    Guys can someone please help me,this formula i need is way out of my league.
    in this attachment you can see cell 6 is going to be a handicap for players to play off,this need to adjust up or down according to the scores in F6 TO K6.the formula im after is if a score is from 0 to 20 add 3 then 21 to 25 add 2 then 26 to 30 add 1 and 31 to 36 no change,then i also need 37 to 39 -1 then 40 to 42 -2, 43 to 45 -3 and finally 46 or greater -4 as you can see it is a mighty formula if anybody can help much appreciated
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-10-2007
    Posts
    97

    Re: Golf Handicap

    guys just resubmitting this incase anybody has a clue how to do this
    ,your help would be greatly appreciated

  3. #3
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel for Mac 16.31
    Posts
    72

    Re: Golf Handicap

    Perhaps you could create a table called stableford_points

    0 3
    21 2
    26 1
    30 1
    36 0
    39 -1
    42 -2
    45 -3
    46 -4

    Then create 6 columns, called "score adjustment" - so where you keep track of every adjustment per score. Values of these are

    =VLOOKUP(F6,stableford_points,2,TRUE)

    then, sum all score adjustments and add to the playing handicap?

  4. #4
    Registered User
    Join Date
    02-10-2007
    Posts
    97

    Re: Golf Handicap

    Thanks for the reply im a bit of a novice on excel not quite getting it sorry.
    think i need laymans terms if you could.

  5. #5
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel for Mac 16.31
    Posts
    72

    Re: Golf Handicap

    For a fellow golfer... hope that helps.

  6. #6
    Registered User
    Join Date
    02-10-2007
    Posts
    97

    Re: Golf Handicap

    What a star exactly bang on thanks for your help ,But one thing how did you get (stableford_points) in the formula im following it ion a spare cell trying to learn but im lost when i get to here.

    cheers for your time and patience
    Last edited by dodger999; 07-09-2009 at 10:55 AM.

  7. #7
    Registered User
    Join Date
    02-10-2007
    Posts
    97

    Re: Golf Handicap

    found it doh!!! cheers mate

  8. #8
    Registered User
    Join Date
    03-16-2009
    Location
    London, UK
    MS-Off Ver
    Excel for Mac 16.31
    Posts
    72

    Re: Golf Handicap

    You're welcome :-) Don't forget to mark your entry as [SOLVED] if it is.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1