Robert,
I sent the spreadsheet to your email address. Let me know what you think. I
added some other stuff too.

Thanks again,
Mike

"robert morris" wrote:

Mike,

I'm a little surprised to hear you say you have your spread sheet set up on
rows (across). Do you then keep each hole in columns (down)? Almost every
scorecard I have seen has the individual hole scores horizontally. Just
curious. Would like to see your spreadsheet as I do some golf scoring. If
you wouldn't mind, could you email a copy to me at .


Bob M.



"Mike" wrote:

Bob,
Thank you and David for you help. I will try the ideas you sent me and let
you know how it worked.

Mike

"robert morris" wrote:

Mike,

If you go to the last 2-3 postings between David and myself, you should be
able to complete your project.

Bob M.


"Mike" wrote:

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!