G
Golf Scrambler
I'm setting up a spreadsheet to determine winners of a 3 person golf
scramble. The highest handicap of a team member can not be greater than 12
strokes higher than the low handicap team members handicap. For example if
the low handicap member of the team has a 5 handicap, the other 2 members of
the team can not have handicaps over 17 so if one or both are above 17 then
their handicaps must be reduced to 17. In the subject above I would put each
person's handicap in a different cell e.g. A1, B1, and C1 with the total of
the 3 in D1. Then I would use another cell, say E1, to calculate 15% of the
total in D1. I'm using Office 2003.
scramble. The highest handicap of a team member can not be greater than 12
strokes higher than the low handicap team members handicap. For example if
the low handicap member of the team has a 5 handicap, the other 2 members of
the team can not have handicaps over 17 so if one or both are above 17 then
their handicaps must be reduced to 17. In the subject above I would put each
person's handicap in a different cell e.g. A1, B1, and C1 with the total of
the 3 in D1. Then I would use another cell, say E1, to calculate 15% of the
total in D1. I'm using Office 2003.