.. made to work if the h/cap were variable ..

Thought variable handicaps (besides variable par and stroke indexes) was
already catered for in the suggested formulas, no? (Based, of course, on a
best effort interp of the complexities posed by a non-golfer <g)

In the sample file provided, in Sheet1, try inputting other handicaps (but
with the same dummy scores for easy comparison) on subsequent rows 7 - 10
(I've pre-loaded the formulas to row10). Also keep the other 2 variables,
par and the stroke indexes unchanged to comparison. Check whether the
formula returns are as expected for a couple of test h/cap cases. Try it and
post back.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"kevhatch" wrote in message
...
Thx Max,
That works great with a 28 handicap. Is there a way it can be , as they
can change for each player from time to
time?

Players handicap of:
1 to 18 allowed 1stroke only on stroke index holes corresponding to their
h/cap.
i.e. player h/cap of 3 allowed one stroke on holes of s/index 1 - 3 etc.

Players handicap of:
19 to 28 allowed 1 stroke on all 18 holes, in addition to 1 extra stroke
on
each of the hardest holes corresponding to their h/cap.
i.e. player h/cap of 22 allowed one stroke for each hole plus one extra
stroke on holes of s/index 1 - 4 etc.
Thx again