software

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!
--
Thanks,
Gary.


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--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=521914
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-B3lt;-1,0,B2-B3 2)
and copy across as far as needed

This formula gives 0 points for anything worse than a bogey--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=521914