Golf betting game - Vegas

[vanvoord]

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?

 

[mrshl9898]

Looks to be working:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Par[/TD]
[TD]T1 P1[/TD]
[TD]T1 P2[/TD]
[TD]T2 P1[/TD]
[TD]T2 P2[/TD]
[TD]T1 SCORE[/TD]
[TD]T2 SCORE[/TD]
[TD]WINNER[/TD]
[TD]POINTS[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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

 

[Michael M]

Maybe this

Excel 2007
	A	B	C	D	E	F	G	H	I
1	Par	T1 P1	T1 P2	T2 P1	T2 P2	T1 SCORE	T2 SCORE	WINNER	POINTS
2	4	4	6	3	7	64	37	64	27
Sheet1

Cell Formulas
Range	Formula
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)

 

[Michael M]

@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

 

[vanvoord]

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