Discussion Re: How to enter a formula that will automatically reduce a score of over a specific value in Excel
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3418710#M147750
<P>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.</P><P> </P><TABLE width="1709"><TBODY><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122"> </TD><TD width="440">FRONT </TD><TD width="97"> </TD><TD width="429">BACK</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122">HOLE</TD><TD width="46">1</TD><TD width="48">2</TD><TD width="46">3</TD><TD width="47">4</TD><TD width="48">5</TD><TD width="51">6</TD><TD width="50">7</TD><TD width="51">8</TD><TD width="53">9</TD><TD width="47">10</TD><TD width="48">11</TD><TD width="48">12</TD><TD width="46">13</TD><TD width="50">14</TD><TD width="48">15</TD><TD width="46">16</TD><TD width="48">17</TD><TD width="48">18</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122">H/C</TD><TD width="46">7</TD><TD width="48">5</TD><TD width="46">17</TD><TD width="47">9</TD><TD width="48">1</TD><TD width="51">15</TD><TD width="50">13</TD><TD width="51">3</TD><TD width="53">11</TD><TD width="97"> </TD><TD width="47">12</TD><TD width="48">16</TD><TD width="48">14</TD><TD width="46">4</TD><TD width="50">6</TD><TD width="48">18</TD><TD width="46">8</TD><TD width="48">2</TD><TD width="48">10</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119">HANDICAP</TD><TD width="122">PAR</TD><TD width="46">4</TD><TD width="48">5</TD><TD width="46">3</TD><TD width="47">5</TD><TD width="48">4</TD><TD width="51">4</TD><TD width="50">3</TD><TD width="51">4</TD><TD width="53">4</TD><TD width="97"> </TD><TD width="47">4</TD><TD width="48">3</TD><TD width="48">4</TD><TD width="46">4</TD><TD width="50">5</TD><TD width="48">3</TD><TD width="46">4</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="260">ADJUSTER TOTAL SCORE</TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122"> </TD><TD width="46"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="47"> </TD><TD width="48"> </TD><TD width="51"> </TD><TD width="50"> </TD><TD width="51"> </TD><TD width="53"> </TD><TD width="97"> </TD><TD width="47"> </TD><TD width="48"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="50"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="48"> </TD><TD width="48"> </TD><TD width="260"> </TD></TR><TR><TD width="242">Mike Aroz</TD><TD width="119">12</TD><TD width="122"> </TD><TD width="46">5</TD><TD width="48">5</TD><TD width="46">4</TD><TD width="47">6</TD><TD width="48">5</TD><TD width="51">5</TD><TD width="50">3</TD><TD width="51">3</TD><TD width="53">5</TD><TD width="97"> </TD><TD width="47">5</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="46">5</TD><TD width="50">6</TD><TD width="48">4</TD><TD width="46">5</TD><TD width="48">4</TD><TD width="48">6</TD><TD width="260"> </TD></TR><TR><TD width="242">William Bonnett</TD><TD width="119">2</TD><TD width="122"> </TD><TD width="46">4</TD><TD width="48">5</TD><TD width="46">6</TD><TD width="47">4</TD><TD width="48">5</TD><TD width="51">4</TD><TD width="50">3</TD><TD width="51">4</TD><TD width="53">4</TD><TD width="97"> </TD><TD width="47">3</TD><TD width="48">3</TD><TD width="48">8</TD><TD width="46">5</TD><TD width="50">6</TD><TD width="48">4</TD><TD width="46">4</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="260"> </TD></TR></TBODY></TABLE><P> </P>Tue, 24 May 2022 05:53:34 GMTKevin_Caldewell2022-05-24T05:53:34ZWhat is the formula to divide an odd number
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412663#M147570
<P>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?</P><P> </P>Mon, 23 May 2022 04:10:43 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412663#M147570Kevin_Caldewell2022-05-23T04:10:43ZRe: What is the formula to divide an odd number
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412698#M147572
<P><LI-USER uid="1397965"></LI-USER> Let's say the 5 handicap sits in cell A1. Then, in B1 you enter:</P><P><STRONG>=INT(A1/2)</STRONG> to get 2, </P><P>And in C1 you enter:</P><P><STRONG>=A1-B1</STRONG> to get 3</P><P> </P>Mon, 23 May 2022 04:32:00 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412698#M147572Riny_van_Eekelen2022-05-23T04:32:00ZRe: What is the formula to divide an odd number
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412699#M147573
Thank you that should work perfectlyMon, 23 May 2022 04:38:47 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3412699#M147573Kevin_Caldewell2022-05-23T04:38:47ZRe: How to enter a formula that will automatically reduce a score of over a specific value
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3418710#M147750
<P>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.</P><P> </P><TABLE width="1709"><TBODY><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122"> </TD><TD width="440">FRONT </TD><TD width="97"> </TD><TD width="429">BACK</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122">HOLE</TD><TD width="46">1</TD><TD width="48">2</TD><TD width="46">3</TD><TD width="47">4</TD><TD width="48">5</TD><TD width="51">6</TD><TD width="50">7</TD><TD width="51">8</TD><TD width="53">9</TD><TD width="47">10</TD><TD width="48">11</TD><TD width="48">12</TD><TD width="46">13</TD><TD width="50">14</TD><TD width="48">15</TD><TD width="46">16</TD><TD width="48">17</TD><TD width="48">18</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122">H/C</TD><TD width="46">7</TD><TD width="48">5</TD><TD width="46">17</TD><TD width="47">9</TD><TD width="48">1</TD><TD width="51">15</TD><TD width="50">13</TD><TD width="51">3</TD><TD width="53">11</TD><TD width="97"> </TD><TD width="47">12</TD><TD width="48">16</TD><TD width="48">14</TD><TD width="46">4</TD><TD width="50">6</TD><TD width="48">18</TD><TD width="46">8</TD><TD width="48">2</TD><TD width="48">10</TD><TD width="260"> </TD></TR><TR><TD width="242"> </TD><TD width="119">HANDICAP</TD><TD width="122">PAR</TD><TD width="46">4</TD><TD width="48">5</TD><TD width="46">3</TD><TD width="47">5</TD><TD width="48">4</TD><TD width="51">4</TD><TD width="50">3</TD><TD width="51">4</TD><TD width="53">4</TD><TD width="97"> </TD><TD width="47">4</TD><TD width="48">3</TD><TD width="48">4</TD><TD width="46">4</TD><TD width="50">5</TD><TD width="48">3</TD><TD width="46">4</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="260">ADJUSTER TOTAL SCORE</TD></TR><TR><TD width="242"> </TD><TD width="119"> </TD><TD width="122"> </TD><TD width="46"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="47"> </TD><TD width="48"> </TD><TD width="51"> </TD><TD width="50"> </TD><TD width="51"> </TD><TD width="53"> </TD><TD width="97"> </TD><TD width="47"> </TD><TD width="48"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="50"> </TD><TD width="48"> </TD><TD width="46"> </TD><TD width="48"> </TD><TD width="48"> </TD><TD width="260"> </TD></TR><TR><TD width="242">Mike Aroz</TD><TD width="119">12</TD><TD width="122"> </TD><TD width="46">5</TD><TD width="48">5</TD><TD width="46">4</TD><TD width="47">6</TD><TD width="48">5</TD><TD width="51">5</TD><TD width="50">3</TD><TD width="51">3</TD><TD width="53">5</TD><TD width="97"> </TD><TD width="47">5</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="46">5</TD><TD width="50">6</TD><TD width="48">4</TD><TD width="46">5</TD><TD width="48">4</TD><TD width="48">6</TD><TD width="260"> </TD></TR><TR><TD width="242">William Bonnett</TD><TD width="119">2</TD><TD width="122"> </TD><TD width="46">4</TD><TD width="48">5</TD><TD width="46">6</TD><TD width="47">4</TD><TD width="48">5</TD><TD width="51">4</TD><TD width="50">3</TD><TD width="51">4</TD><TD width="53">4</TD><TD width="97"> </TD><TD width="47">3</TD><TD width="48">3</TD><TD width="48">8</TD><TD width="46">5</TD><TD width="50">6</TD><TD width="48">4</TD><TD width="46">4</TD><TD width="48">4</TD><TD width="48">5</TD><TD width="260"> </TD></TR></TBODY></TABLE><P> </P>Tue, 24 May 2022 05:53:34 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3418710#M147750Kevin_Caldewell2022-05-24T05:53:34ZRe: How to enter a formula that will automatically reduce a score of over a specific value
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3419482#M147763
<P><LI-USER uid="1397965"></LI-USER> 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.</P><P> </P><P> </P>Tue, 24 May 2022 09:48:03 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3419482#M147763Riny_van_Eekelen2022-05-24T09:48:03ZRe: How to enter a formula that will automatically reduce a score of over a specific value
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3422325#M147849
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?Tue, 24 May 2022 16:26:16 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3422325#M147849Kevin_Caldewell2022-05-24T16:26:16ZRe: What is the formula to divide an odd number
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3422488#M147851
hello I would like help I need the formula of a worksheet that updates the data alone but only on dashed datesTue, 24 May 2022 16:38:02 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3422488#M147851CleversonSouza2022-05-24T16:38:02ZRe: How to enter a formula that will automatically reduce a score of over a specific value
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3426135#M147955
<P><LI-USER uid="1397965"></LI-USER> Changed the file a bit. See attached.</P>Wed, 25 May 2022 09:06:40 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3426135#M147955Riny_van_Eekelen2022-05-25T09:06:40ZRe: What is the formula to divide an odd number
https://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3426146#M147956
<P><LI-USER uid="1400046"></LI-USER> Please remove your post and start a new discussion as it is not related to the thread you posted your question in.</P>Wed, 25 May 2022 09:09:04 GMThttps://techcommunity.microsoft.com/t5/excel/what-is-the-formula-to-divide-an-odd-number/m-p/3426146#M147956Riny_van_Eekelen2022-05-25T09:09:04Z