Formula Help

G

Gazza

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!
 
S

SteveG

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
 
C

Cutter

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

Sports summary sheet - think I put this in wrong place originally 1
excel golf scores, how do I add the scores for all par 3's etc 2
Complex formula 0
VBA works in orignal but fails in copy of database 1
template for scoring a golf league 1
Average with criteria for adjacent cells ? 1
Only Calculating Numerics 5
Grow/Shrink Text gradually from slide to slide 0

Top