I’m having problems with my Win Penalty Formula.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I use a VB code to enter a trigger code of “1” in the corresponding Winners row, at Column “U”<o></o>
<o></o>
Below are the general parameters I’m working to. With an assumed working on Row 10<o></o>
<o></o>
General Play Penalties - in (“S10”)<o></o>
0 - if score of 37 or less.<o></o>
1 - If score of 38 or 39.<o></o>
2 - If score of 40 or more.<o></o>
3 - If score of 45 or more.<o></o>
4 - If score of 50 or more.<o></o>
<o></o>
Win Penalties in (“T10”)
1 deducted for a score of 35 points or less.<o></o>
2 deducted for a score of 36 points or more.<o></o>
<o></o>
But:
Only 1 deducted if already cut >=2 under General Play rules.<o></o>
Or -<o></o>
Only 1 deducted if Handicap is at 9 or less and if already cut >=1 under General Play rules. ####### This line is the problem area.<o></o>
<o></o>
<o></o>
The Players Handicap are shown in (“F10”)<o></o>
<o></o>
The formulas I have already and work as required are:-<o></o>
<o></o>
In (“S10”) I have: “=IF(J10>=50,4,IF(J10>=45,3,IF(J10>=40,2,IF(J10>=38,1,IF(J10<=37,0)))))”<o></o>
<o></o>
In (“T10”) I have: “=IF(U10=1,(IF(S10>=2,1,IF(S10=1,2,IF(S10>=0,2)))),0)”<o></o>
<o></o>
But I can’t seem to introduce the last line of the Win Penalties into the Win Penalty formula in (“T10”).<o></o>
I.e. only cut 1 if their Handicap is in single figures. (<=9)<o></o>
<o></o>
Can anyone assist with this part of the formula?<o></o>
<o></o>
Thanks.<o></o>
fficeffice" /><o></o><o
></o>I use a VB code to enter a trigger code of “1” in the corresponding Winners row, at Column “U”<o
></o><o
></o>Below are the general parameters I’m working to. With an assumed working on Row 10<o
></o><o
></o>General Play Penalties - in (“S10”)<o
></o>0 - if score of 37 or less.<o
></o>1 - If score of 38 or 39.<o
></o>2 - If score of 40 or more.<o
></o>3 - If score of 45 or more.<o
></o>4 - If score of 50 or more.<o
></o><o
></o>Win Penalties in (“T10”)
1 deducted for a score of 35 points or less.<o
></o>2 deducted for a score of 36 points or more.<o
></o><o
></o>But:
Only 1 deducted if already cut >=2 under General Play rules.<o
></o>Or -<o
></o>Only 1 deducted if Handicap is at 9 or less and if already cut >=1 under General Play rules. ####### This line is the problem area.<o
></o><o
></o><o
></o>The Players Handicap are shown in (“F10”)<o
></o><o
></o>The formulas I have already and work as required are:-<o
></o><o
></o>In (“S10”) I have: “=IF(J10>=50,4,IF(J10>=45,3,IF(J10>=40,2,IF(J10>=38,1,IF(J10<=37,0)))))”<o
></o><o
></o>In (“T10”) I have: “=IF(U10=1,(IF(S10>=2,1,IF(S10=1,2,IF(S10>=0,2)))),0)”<o
></o><o
></o>But I can’t seem to introduce the last line of the Win Penalties into the Win Penalty formula in (“T10”).<o
></o>I.e. only cut 1 if their Handicap is in single figures. (<=9)<o
></o><o
></o>Can anyone assist with this part of the formula?<o
></o><o
></o>Thanks.<o
></o>
