Golf betting game - Vegas

vanvoord

New Member
Joined
Feb 17, 2019
Messages
3
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?
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

mrshl9898

Well-known Member
Joined
Feb 6, 2012
Messages
1,611
Looks to be working:

ParT1 P1T1 P2T2 P1T2 P2T1 SCORET2 SCOREWINNERPOINTS
44637

<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:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Maybe this

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Par</td><td style=";">T1 P1</td><td style=";">T1 P2</td><td style=";">T2 P1</td><td style=";">T2 P2</td><td style=";">T1 SCORE</td><td style=";">T2 SCORE</td><td style=";">WINNER</td><td style=";">POINTS</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">6</td><td style="text-align: right;;">3</td><td style="text-align: right;;">7</td><td style="text-align: right;;">64</td><td style="text-align: right;;">37</td><td style="text-align: right;;">64</td><td style="text-align: right;;">27</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F2</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">D2<A2,E2<A2</font>),C2&B2,B2&C2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">G2</th><td style="text-align:left">=IF(<font color="Blue">OR(<font color="Red">B2<A2,C2<A2</font>),E2&D2,D2&E2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">H2</th><td style="text-align:left">=IF(<font color="Blue">F2>G2,F2,G2</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">I2</th><td style="text-align:left">=IF(<font color="Blue">H2=F2,H2-G2,H2-F2</font>)</td></tr></tbody></table></td></tr></table><br />
 
Last edited:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,693
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
@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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,206
Messages
5,594,832
Members
413,943
Latest member
Dhornsby21

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top