A golf course has 18 holes
Each hole is ranked 1-18 with 1 being hardest
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
Players have indexes of 0-36
<o></o>
If a player has an index of 1, his GROSS score on the #1 ranked hole is reduced by 1
<o></o>
If a player has an index of 2, his GROSS scores on ranked holes 1 and 2 are reduced by 1
<o></o>
If a player has an index of 18, every GROSS score is reduced by 1
<o></o>
If a player has an index above 18, his GROSS scores for the hardest holes are reduced by 2
<o></o>
<o>My WorkSheet: </o>
W11 is the player’s index
B9 is the hole’s ranking
F2 is the player’s GROSS score
<o></o>
I use this formula to calculate the player’s NET score
<o></o>
<o></o>
Now comes the challenge…
Some really good players have negative indexes
So, their GROSS scores on the easiest ranked holes need to be increased by 1
<o></o>
I cannot figure out the IF. Is there a better way?
Each hole is ranked 1-18 with 1 being hardest
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>Players have indexes of 0-36
<o
></o>If a player has an index of 1, his GROSS score on the #1 ranked hole is reduced by 1
<o
></o>If a player has an index of 2, his GROSS scores on ranked holes 1 and 2 are reduced by 1
<o
></o>If a player has an index of 18, every GROSS score is reduced by 1
<o
></o>If a player has an index above 18, his GROSS scores for the hardest holes are reduced by 2
<o
></o><o
>My WorkSheet: </o>W11 is the player’s index
B9 is the hole’s ranking
F2 is the player’s GROSS score
<o
></o>I use this formula to calculate the player’s NET score
Code:
=IF(W11>=18+B9,-2,IF(W11>=B9,-1,0))+F2<o
></o>Now comes the challenge…
Some really good players have negative indexes
So, their GROSS scores on the easiest ranked holes need to be increased by 1
<o
></o>I cannot figure out the IF. Is there a better way?
