# Bet Generator for Golf Course

#### Vighper

##### New Member
At our golf course, I have a spreadsheet that takes two people and matches them against two other people. It will calculate their net scores on a hole (if one person's handicap is 2, then the two hardest holes, it will take the gross score and convert it to a net score) and then the bet is called and it lets me know what team won over 18 holes.

What I want to do is a version called "two down automatics" where if Player A wins the first hole, he is one up, if he wins the next hole, he is 2 up and then the "press" (a press is a new bet starting because the person lost two holes before winning a hole) starts and he becomes 2 & 0; if Player A wins the next hole, he is now up 3 & 1. However, if Player A loses the third hole, the match is now (Player A 1/-1).

It is hard to figure out the formula in the event that the bet goes back and forth because each time you reach "2" in a bet, it adds a new bet to track. So if Player A wins the first five holes, and loses holes 6 through 9, he will be:
Hole 1: 1up
Hole 2: 2&0
Hole 3: 3&1
Hole 4: 4/2/0
Hole 5: 5/3/1
Hole 6: 4/2/0
Hole 7: 3/1/-1
Hole 8: 2/0/-2/0
Hole 9: 1/-1/-3/-1 and player B wins two plays (the 1 and -1 cancel each other out).

It would be the same process for the back nine holes too.

Would this be too difficult of a formula to set up? When I've looked at it, I have tried to use nine separate formulas to look at the previous bet and determine how to score the next one based on the contents of the two cells (Player A and Player B).

Thanks,
mike

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Replies
9
Views
350
Replies
5
Views
241
Replies
1
Views
190
Replies
0
Views
152
Replies
4
Views
290

1,218,920
Messages
6,145,223
Members
450,602
Latest member
AceSpace

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