David,

I used your last formula =A9-MIN(2,INT(A7/A5)) and it works perfectly.
Mike should be able to use it.

Bob M.



"David Biddulph" wrote:

If you compare your layout with mine, and look at my formulae, then you need
to change my formula from
=IF(F$1=2*C2,D2-2,IF(F$1=C2,D2-1,D2)) to
=IF(A7=2*A5,A9-2,IF(A7=A5,A9-1,A9)), which you will see is similar to your
formula but you had missed the second test.

The alternative way would change my
=D2-MIN(2,INT(F$1/C2)) to
=A9-MIN(2,INT(A7/A5))
--
David Biddulph

"robert morris" wrote in message
...
David,

Typically a golf scorecard reads down.

A1 Hole #1
a2 Par
a3 4
a4 Hndcp
a5 12
a6 Player Handcp
a7 25
a8 Gross
a9 5
a10 Net
a11 3

In A11 I've entered the following;

=IF(A7=A5*2,A9-2,A9-1) Works perfectly, but, a player should never
receive a reduction in score where his handicap is LESS than the handicap
for
the hole. Can you add/adjust my formula to reflect a net score the same
as
the gross score. i.e. A7 is less than A5, then A11 would be the same as
A9.
I'm missing something!

"David Biddulph" wrote:

You haven't told us what formulae you've tried, and in what way they
didn't
meet your requirements, so we can't help you to correct your formulae.
Please remember next time to tell us the formula and what result it gives
gor given inputs, and what result you had expected.

To start from square one, if the handicap for the hole is in column C,
the
gross score for the player in column D, and the player's handicap in F1,
then in E2 the formula for the net score could be either
=IF(F$1=2*C2,D2-2,IF(F$1=C2,D2-1,D2)) or
=D2-MIN(2,INT(F$1/C2))
--
David Biddulph

"Mike" wrote in message
...
I'm relatively new to excel and am trying to put a spreadsheet together
for
golf game results. I am trying to give a cell a value that represents
the
net
score for each player on each hole. Example: Hole #1 is a par 4 with a
handicap of 12, the player has a handicap of 25 and scores a 5 on the
hole.
The net score for that hole should be the gross score minus 2, for a
net
3.
Basically, if the player's handicap is more than or equal to the hole
handicap then the player's net score is the gross score minus 1. If the
player's handicap is more than or equal to 2 times the hole handicap
then
the
player's net score is the gross score minus 2. Everything I've tried so
far
hasn't worked. Help!