Golfers! Need Help Calculating Hole-by-Hole Net Handicaps
Thanks. However, this formula doesn't seem to work. It's producing a
"#VALUE!" error. This seems like this would be a simple calculation. Any
other ideas?
And by the way, yes, I have all of the hole #'s and handicaps in separate
cells, and without the "HCP." That was just a visual display for the
discussion boards.
"Fred Smith" wrote:
Golfer's handicap in A1, descriptions in a2:a19
=INT(A$1/18)+(MOD(A$1,18)=--RIGHT(A2,2))
Copy down
As an aside, I would put the hole numbers and their handicaps in separate
cells. They would be easier to work with.
Regards,
Fred.
"Scott" wrote in message
...
This seems like it would be very easy, but apparently it's either not, or
I'm
not thinking clearly.
Cells A2:A19 have the Hole # followed by the hole handicap (ranked 1
through
18, 1 being most difficult): So, in this example, let's say that the
following information is true for cells A2:A19:
1- HCP 11
2- HCP 17
3- HCP 3
4- HCP 1
5- HCP 13
6- HCP 7
7- HCP 5
8- HCP 15
9- HCP 9
10- HCP 4
11- HCP 18
12- HCP 2
13- HCP 10
14- HCP 16
15- HCP 8
16- HCP 14
17- HCP 6
18- HCP 12
Now, let's assume that our sample golfer has a 27 handicap, meaning he
will
receive 1 shot on holes 1-18, and receive 1 shot on the HCP holes ranked
1-9.
So, in our example, he would receive 1 shot on #1, 1 shot on #2, 2 shots
on
#3, 2 shots on #4, and so on...
What formula would I use to calculate the number of shots player would
receive on each hole? Any ideas?
|