Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I'm trying to construct a formula to display the points scored in golf for
the Stapleford scoring system. The way it works is that if a player scores 1
over the par (score for the hole) then the player would get 1 point. If =par
then 2 points, if -1 under par then 3 points and if -2 under par then 4
points. The scores are in individual cells for each hole played and the
Stapleford points in another cell. Please help!
 
This works if you have your par values in column A, actual score in B
then in C you enter this formula to calc the Stapleford point system,

=IF(B2=A2,2,IF(B2=A2+1,1,IF(B2=A2-1,3,IF(B2=A2-2,4,0))))


HTH

Steve
 
With your Par Values in Row 2 from Col B onward
and your actual scores in Row 3 from Col B onward

In B4 type: =IF(B2-B3<-1,0,B2-B3+2)
and copy across as far as needed

This formula gives 0 points for anything worse than a bogey
 

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

excel golf scores, how do I add the scores for all par 3's etc 2
Sports summary sheet - think I put this in wrong place originally 1
template for scoring a golf league 1
Golf Score Formula needs tweaking 2
Golf Scores 10
Formula 9
counting occurences of cell matches 1
Excel Excel conundrum - I've tried and tried, but 10

Back
Top