Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Location
    Kapaa, Hawaii, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

    Thanks for any help you can provide,
    Willie B.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    New Lounger
    Join Date
    Feb 2005
    Location
    Kapaa, Hawaii, USA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •