Thread: Golf Bet Sheet Thanks: 0 Likes: 0

1. Golf Bet Sheet

So I am creating a bet sheet to track all of my bets for a golf tournament. The sheet has the bet amount and then a cell for my score and my openents score. I was trying to figure out a formula that stated that IF my score was higher than the opponents score to return a negative number (loss) equal to my bet amount but if my score was lower than the opponents score to return a positive number equal to my bet amount. So A1 might have the bet Amount, A2 my score, B2 my opponents score and C2 would be either the win or loss.

Can anyone help ?  Reply With Quote

2. Re: Golf Bet Sheet

Excel 2013/2016
ABCD
1Bet amountMy scorehis Scorewin +/-
2 \$ 5.00 54-5
3

Sheet1

Worksheet Formulas
CellFormula
D2=IF(B2<C2,A2,IF(B2>C2,A2*-1,"Square"))  Reply With Quote

3. Re: Golf Bet Sheet

Maybe another option for the whole 18 holes

Excel 2013/2016
ABCD
1Bet amount
2 \$ 5.00
3HoleMy scorehis Scorewin +/-
4154-5
5254-10
6355-10
74
85
96
107
118
129
1310
1411
1512
1613
1714
1815
1916
2017
2118

Sheet1

Worksheet Formulas
CellFormula
D4=IF(B4<C4,B2,IF(B4>C4,B2*-1))
D5=IF(OR(B5="",C5=""),"",IF(B5=C5,D4,IF(B5<C5,\$B\$2+D4,IF(B5>C5,\$B\$2*-1+D4))))
D6=IF(OR(B6="",C6=""),"",IF(B6=C6,D5,IF(B6<C6,\$B\$2+D5,IF(B6>C6,\$B\$2*-1+D5))))
D7=IF(OR(B7="",C7=""),"",IF(B7=C7,D6,IF(B7<C7,\$B\$2+D6,IF(B7>C7,\$B\$2*-1+D6))))
D8=IF(OR(B8="",C8=""),"",IF(B8=C8,D7,IF(B8<C8,\$B\$2+D7,IF(B8>C8,\$B\$2*-1+D7))))
D9=IF(OR(B9="",C9=""),"",IF(B9=C9,D8,IF(B9<C9,\$B\$2+D8,IF(B9>C9,\$B\$2*-1+D8))))
D10=IF(OR(B10="",C10=""),"",IF(B10=C10,D9,IF(B10<C10,\$B\$2+D9,IF(B10>C10,\$B\$2*-1+D9))))
D11=IF(OR(B11="",C11=""),"",IF(B11=C11,D10,IF(B11<C11,\$B\$2+D10,IF(B11>C11,\$B\$2*-1+D10))))
D12=IF(OR(B12="",C12=""),"",IF(B12=C12,D11,IF(B12<C12,\$B\$2+D11,IF(B12>C12,\$B\$2*-1+D11))))
D13=IF(OR(B13="",C13=""),"",IF(B13=C13,D12,IF(B13<C13,\$B\$2+D12,IF(B13>C13,\$B\$2*-1+D12))))
D14=IF(OR(B14="",C14=""),"",IF(B14=C14,D13,IF(B14<C14,\$B\$2+D13,IF(B14>C14,\$B\$2*-1+D13))))
D15=IF(OR(B15="",C15=""),"",IF(B15=C15,D14,IF(B15<C15,\$B\$2+D14,IF(B15>C15,\$B\$2*-1+D14))))
D16=IF(OR(B16="",C16=""),"",IF(B16=C16,D15,IF(B16<C16,\$B\$2+D15,IF(B16>C16,\$B\$2*-1+D15))))
D17=IF(OR(B17="",C17=""),"",IF(B17=C17,D16,IF(B17<C17,\$B\$2+D16,IF(B17>C17,\$B\$2*-1+D16))))
D18=IF(OR(B18="",C18=""),"",IF(B18=C18,D17,IF(B18<C18,\$B\$2+D17,IF(B18>C18,\$B\$2*-1+D17))))
D19=IF(OR(B19="",C19=""),"",IF(B19=C19,D18,IF(B19<C19,\$B\$2+D18,IF(B19>C19,\$B\$2*-1+D18))))
D20=IF(OR(B20="",C20=""),"",IF(B20=C20,D19,IF(B20<C20,\$B\$2+D19,IF(B20>C20,\$B\$2*-1+D19))))
D21=IF(OR(B21="",C21=""),"",IF(B21=C21,D20,IF(B21<C21,\$B\$2+D20,IF(B21>C21,\$B\$2*-1+D20))))  Reply With Quote

User Tag List

Tags for this Thread

amount, bet, opponents, score, sheet  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•