1. ## Excel question (Excel2003)

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.

Willie B.

2. ## Re: Excel question (Excel2003)

Welcome to Woody's Lounge!

Try this:

=IF(ISBLANK(D7),"",IF(AND(0<=\$W7-D\$3,\$W7-D\$3<18),D7-1,IF(\$W7-D\$3<0,D7,D7-2)))

3. ## Re: Excel question (Excel2003)

Thanks HansV. I swear I tried that but I must not have gotten all the ,,, and ((())) in there just right. That works like a charm. This will get me to the 19th hole and a cold beer a little faster now.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•