May 22 2022 09:07 PM - edited May 22 2022 09:10 PM
What is the formula to divide an odd number and enter the higher half in one cell and the lower in a different cell? For example, in golf you have a handicap and lets say it is 5, you would get 3 strokes on the front and 2 on the back. I created a spreadsheet that lists the handicap, but it wants to put 2.5 in both cells front and back, how do I create a formula that will enter the higher of the two values in one cell and the lower value in a different cell?
May 22 2022 09:32 PM
Solution@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
May 22 2022 09:38 PM
May 23 2022 10:53 PM
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 |
May 24 2022 02:48 AM
@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.
May 24 2022 09:26 AM
May 24 2022 09:38 AM
May 25 2022 02:06 AM
@Kevin_Caldewell Changed the file a bit. See attached.
May 25 2022 02:09 AM
@CleversonSouza Please remove your post and start a new discussion as it is not related to the thread you posted your question in.