# Golf Handicap

1. ## Golf Handicap

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

2. ## Re: Golf Handicap

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

3. ## 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)

4. ## 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. ## Re: Golf Handicap

For a fellow golfer... hope that helps.

6. ## 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

7. ## Re: Golf Handicap

found it doh!!! cheers mate

8. ## Re: Golf Handicap

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

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

#### 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