Hi there,
I am building a scorecard system for our annual golf day. Everything is working, but then the curve ball came where the want a skins format and the holes that are squared should be carried over. That where my scorecard failed me.
I used a if formula that determine which team is winning the hole, the data is in a table adjacent to the table below. In that table the values are determined based on shots played and handicap, player a is a 18 and he played 4 on hole 1 (par 4) and he gets 3 points etc. The formula in the score cell is if(AB7>AB10;B2;0). B2 is the skin value and AB7 and AB10 are the highest scores of each team, based on handicap.
1. Hole 1 has been won by team AB and they must get four points for the skin and team CD gets 0 the value 4 for the skin.
2. Hole 2 was halved and the points (7) will be carried over to hole 3.
3. Hole three was won by team CD and they will get the points for hole 2 and 3, hence getting 8 points
4. The problem is that i have the If function in the score cell. Is there a way to keep the score function in tact and enhance the formula to determine the following if hole 2 score are zero for both teams. Then the formula IF(AB7>AB10;B2;0) must include the criteria but only sum it to the highest value.
If you can assist me it will be appreciated.
Thank you
Buks
<tbody>
</tbody>
I am building a scorecard system for our annual golf day. Everything is working, but then the curve ball came where the want a skins format and the holes that are squared should be carried over. That where my scorecard failed me.
I used a if formula that determine which team is winning the hole, the data is in a table adjacent to the table below. In that table the values are determined based on shots played and handicap, player a is a 18 and he played 4 on hole 1 (par 4) and he gets 3 points etc. The formula in the score cell is if(AB7>AB10;B2;0). B2 is the skin value and AB7 and AB10 are the highest scores of each team, based on handicap.
1. Hole 1 has been won by team AB and they must get four points for the skin and team CD gets 0 the value 4 for the skin.
2. Hole 2 was halved and the points (7) will be carried over to hole 3.
3. Hole three was won by team CD and they will get the points for hole 2 and 3, hence getting 8 points
4. The problem is that i have the If function in the score cell. Is there a way to keep the score function in tact and enhance the formula to determine the following if hole 2 score are zero for both teams. Then the formula IF(AB7>AB10;B2;0) must include the criteria but only sum it to the highest value.
If you can assist me it will be appreciated.
Thank you
Buks
Hole | 1 | 2 | 3 | 4 | 5 |
Skin Value | 4 | 7 | 1 | 6 | 9 |
Par | 4 | 5 | 3 | 4 | 5 |
Player A (18) | 4 | 5 | 3 | ||
Player B (24) | 6 | 6 | 4 | ||
Score | 3 | 0 | 0 | ||
Player C (12) | 5 | 6 | 3 | ||
Player D (18) | 5 | 5 | 2 | ||
Score | 2 | 0 | ?? |
<tbody>
</tbody>