# 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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

#### mrshl9898

##### Well-known Member
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

Last edited:

#### Michael M

##### Well-known Member
@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

#### vanvoord

##### New Member
Thanks for the responses, I think I've got it now.

Replies
4
Views
7K
Replies
0
Views
204
Replies
0
Views
235
Replies
0
Views
726
Replies
10
Views
928

### Forum statistics

1,141,402
Messages
5,706,232
Members
421,433
Latest member
yash0468 ### 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