Forum Discussion
What is the formula to divide an odd number
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
Kevin_Caldewell Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:
=INT(A1/2) to get 2,
And in C1 you enter:
=A1-B1 to get 3
I would like a formula that calculates the adjusted score based on a specific handicap. For example, the most anyone can post for any one hole is a net double bogey (2 over par), with the key being net. If someone was a 0 handicap he would not get any strokes on any holes and the most he could post for any one hole would be a double bogey, but if he had a 2 handicap, he could post a score on H/C holes 1 and 2, which in the example below is hole 5 and 17, of a 7 (PAR 4 + Double Bogey or 6 + 1 for a total of 7) instead of 6 if he had a 0 H/C. I have entered two players scores and have listed them in order of the hole number played, with the hole H/C and PAR listed below that. The formula would use the scores listed for each hole, allowing for one extra stroke on the H/C holes he is allowed a stroke on, which in this example would be for Mike H/C's 1 through 11, and William 1 and 2 (not holes 1 through 11, and 1 and 2, but H/C holes 1 through 11, and H/C holes 1 and 2. The formula would be written in the cell under the ADJUSTED SCORE COLUMN, and it would have to work with the individual's HANDICAP. I was thinking the formula would have the HANDICAP affect only those scores on holes where his HANDICAP applied, then adding all the ADJUSTED SCORES for a TOTAL ADJUSTER SCORE. Can you help.
FRONT BACK HOLE 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 H/C 7 5 17 9 1 15 13 3 11 12 16 14 4 6 18 8 2 10 HANDICAP PAR 4 5 3 5 4 4 3 4 4 4 3 4 4 5 3 4 4 5 ADJUSTER TOTAL SCORE Mike Aroz 12 5 5 4 6 5 5 3 3 5 5 4 5 5 6 4 5 4 6 William Bonnett 2 4 5 6 4 5 4 3 4 4 3 3 8 5 6 4 4 4 5 - The score card looks good, but my understanding of posting scores is that you can not take more than a net double bogey on any one hole, so if the spreadsheet you provided, William shot a 8 on a par 4, which was on hole 12 that had a handicap of 14, and since William is a 2 handicap he would not get a stroke on that hole, so his net score for posting purposes would be 6, and his total for the back would be reduced by 2 strokes. Again this is for posting purposes. Can you explain further?
Kevin_Caldewell Changed the file a bit. See attached.
Kevin_Caldewell Golfer myself! Happened to have a score card ready that I made earlier for someone else. Put in your numbers as an example. See if this works for you.
- Thank you that should work perfectly
