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

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

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