Numbers formula help

Hi,

Can someone help me with a suggested formula please ?

I've created a spreadsheet with all sorts of scores and graphs for my golfing buddies but I'm struggling with one particular but critical piece of information. I'd like to provide a range of values which would show how each of the golfer's average stableford points score is performing against the par for the course.

For example Player 1's average is 38 points and the par for the course is 36 points this would mean in golfing terms that he is 2 'under' par as opposed to if he had an average of 34 points where he would be 2 'over' par. The value would normally be shown as a plus or minus figure e.g -2 or +2.

If you can solve this it's a big ^^ from me!

I think I worked it out =36-38 gives -2 =36-34 gives 2

Ahemm Einstein I aint

Never used Stableford (or even looked at it) but if I shoot 40 on a par 36 course I am 4 over par rather than 4 under par.

Razormac said:

Never used Stableford (or even looked at it) but if I shoot 40 on a par 36 course I am 4 over par rather than 4 under par.

Click to expand...

It's all about points in Stableford scoring. 1 for Bogey, 2 for Par, 3 for birdie and so on. So on an 18 hole course like ours to play the course to par means scroring 2 points per hole average for a total of 36. Score 40 points and you are under par not over.

That said I think my formula is still wrong

If I understand correctly, shouldn't the formula for an individual hole look something like this:

Points = (Par + 2) - Score

Example, on a Par 3 Hole a player shoots a 4 (bogey)

Points = (3 + 2) - 4 = 1

Probably could grab the code from here
index1
But it seems to be a nested if

Note that anything less than -4 will return a 1 (some better programer would probably put an error condition but you get the gist)
Also note this is generally relative - so your avg would be cell i2 and your par would be j2

Hello lads,

Razor that's good for the score, we manually score it onto a card and I manually input into the sheet..the player declares that they've had 4 shots for 1 point..that sort of thing. What my mates want is an indication as to how their average is doing against the course par. It matters because it will count towards the Order of Merit and there is likely to be some serious cash involved over 20+ weeks.

This is a sample of what I have at the moment.

Ivan, I need to have a closer look at your formula. I'm basically comparing the average score against the par of 36 as you can see in the formula bar.

I built it off of the table on Wikipedia
Stableford - Wikipedia, the free encyclopedia

Standard Stableford Scoring:
Points Strokes taken in relation to adjusted fixed score
0 2 strokes or more over, or no score recorded
1 1 stroke over
2 Same number of strokes
3 1 stroke under
4 2 strokes under
5 3 strokes under
6 4 strokes under

IvanLasston said:

I built it off of the table on Wikipedia
Stableford - Wikipedia, the free encyclopedia

Standard Stableford Scoring:
Points Strokes taken in relation to adjusted fixed score
0 2 strokes or more over, or no score recorded
1 1 stroke over
2 Same number of strokes
3 1 stroke under
4 2 strokes under
5 3 strokes under
6 4 strokes under

Click to expand...

That's exactly right. What my mates wanted was a +/- indicator as to how they are doing against par. TBH they could easily work it out just by looking at their average score and comparing it with the course par but a spreadsheet wouldn't be interesting if it didn't have everything apart from the kitchen sink on it

Upon thinking about it - the only time this wouldn't work if there was a par 6 hole you were playing - and got a hole in one.
Longest golf holes in America - Travel - Active Travel | NBC News
But I have a feeling if you and your friends could do that - you wouldn't need a spreadsheet to keep score. (no offense)

formula score score off par

If your score was in cell A2 and par was 36 then this should work

IF(A2=36,0,−SUM(−36,A2))