# Golf betting game - Vegas

#### vanvoord

##### New Member
I'm working on creating a golf scorecard that can keep track of multiple side games. I'm having trouble with one called Vegas or Casino.

In said game, two man teams compete against each other by combining their scores into one number. For example:

Player A = 4
Player B = 5
Team 1 score of 45 (The low number goes first)

Player C = 5
Player D = 6
Team 2 score of 56

Team 1 wins 11 points.

This is all easy enough. The problem I'm having is with some scoring events that can happen that alter the calculations.

1. If a natural birdie or better is scored, it flips the opposing teams score. So their 56 above becomes 65. However, if the other team matches the birdie with their own birdie or net birdie, then there is no flip.

Currently I'm able to get the flip to display when there is a birdie but I can't figure out how to undo the flip if the birdie is matched. Any thoughts on how to do this?

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Looks to be working:

 Par T1 P1 T1 P2 T2 P1 T2 P2 T1 SCORE T2 SCORE WINNER POINTS 4 4 6 3 7

<tbody>
</tbody>

<c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2><c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2><e2,d2&e2,if(d2><a2,c2<a2),1,0)=1,if(or(d2<a2,e2<a2),1,0)=0),1,0)=1),e2&d2,if(and(if(d2<e2,d2&e2,if(d2><a2,c2<a2),1,0)=1,if(or(d2<a2,e2<a2),1,0)=0),1,0)=1),d2&e2,if(d2<e2,d2&e2,if(d2>Edit, can't seem to post the formulas, will PM you.
<c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2><a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2>
</a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2></a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2></c2,b2&c2,if(b2></a2,c2<a2),1,0)=1,if(or(d2<a2,e2<a2),1,0)=0),1,0)=1),d2&e2,if(d2<e2,d2&e2,if(d2></a2,c2<a2),1,0)=1,if(or(d2<a2,e2<a2),1,0)=0),1,0)=1),e2&d2,if(and(if(d2<e2,d2&e2,if(d2></e2,d2&e2,if(d2></a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2></a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2></c2,b2&c2,if(b2></a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),b2&c2,if(b2<c2,b2&c2,if(b2></a2,e2<a2),1,0)=1,if(or(b2<a2,c2<a2),1,0)=0),1,0)=1),c2&b2,if(and(if(b2<c2,b2&c2,if(b2></c2,b2&c2,if(b2>

Last edited:
Maybe this

Excel 2007
ABCDEFGHI
1ParT1 P1T1 P2T2 P1T2 P2T1 SCORET2 SCOREWINNERPOINTS
24463764376427
Sheet1
Cell Formulas
RangeFormula
F2=IF(OR(D2),C2&B2,B2&C2)
G2=IF(OR(B2),E2&D2,D2&E2)
H2=IF(F2>G2,F2,G2)
I2=IF(H2=F2,H2-G2,H2-F2)

Last edited:
@mrshl9898
I'm guessing you are having formula problems, because of the Less than signs.....they need a space either side of them otherwise they are read as HTML tags

• mrshl9898
Thanks for the responses, I think I've got it now.

Replies
0
Views
828
Replies
2
Views
440
Replies
1
Views
2K
Replies
10
Views
11K
Replies
0
Views
452

### Forum statistics

1,203,174
Messages
6,053,912
Members
444,694
Latest member
JacquiDaly ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back