I play in a golf club with about 70 members and on any Saturday 25-40 show up to play golf.
I have written a spreadsheet to calculate net golf scores on each hole based on the players handicap and the hole rating for each hole. Golfers can have a handicap from 0 to 28. Holes are rated from 1 to 18 with 1 being the most difficult. If a golfer’s handicap is 3 then his net score on the three hardest holes is 1 less that his gross score on each of these holes. If a golfer’s handicap is 22 then his net score is 2 less than his gross score on the four hardest holes and 1 less on the remaining 14 holes.
This calculation was easy but it gives me a range of cells with the net scores on each hole for the golfers who played and 0, -1, -2 for the golfers where no score was entered because they did not play.
What I would like to get is a blank cell if no score is entered for the gross score and the calculated net score if the player played that day. I have tried to use ISBLANK, ISNUMBER, and could not get it right.
My calculation that gives me the net scores is:
=IF(AND(0<=$W7-D$3,$W7-D$3<18),D7-1,IF($W7-D$3<0,D7,D7-2))
This golfer's scores are in D7:U7
His handicap is in W7
The rateing for each hole is in D3:U3
Each golfer is on a row from 7 to 87 with the first score in col D.
All handicaps are in col W.
Thanks for any help you can provide,
Willie B.
