Golf Bet Sheet

[Golfer1973]

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 ?

 

[Michael M]

what about

Excel 2013/2016
	A	B	C	D
1	Bet amount	My score	his Score	win +/-
2	$ 5.00	5	4	-5
3
Sheet1

Cell Formulas
Range	Formula
D2	=IF(B2B2>C2,A2*-1,"Square"))

 

[Michael M]

Maybe another option for the whole 18 holes

Excel 2013/2016
	A	B	C	D
1		Bet amount
2		$ 5.00
3	Hole	My score	his Score	win +/-
4	1	5	4	-5
5	2	5	4	-10
6	3	5	5	-10
7	4
8	5
9	6
10	7
11	8
12	9
13	10
14	11
15	12
16	13
17	14
18	15
19	16
20	17
21	18
Sheet1

Cell Formulas
Range	Formula
D4	=IF(B4B4>C4,B2*-1))
D5	=IF(OR(B5="",C5=""),"",IF(B5=C5,D4,IF(B5B5>C5,$B$2*-1+D4))))
D6	=IF(OR(B6="",C6=""),"",IF(B6=C6,D5,IF(B6B6>C6,$B$2*-1+D5))))
D7	=IF(OR(B7="",C7=""),"",IF(B7=C7,D6,IF(B7B7>C7,$B$2*-1+D6))))
D8	=IF(OR(B8="",C8=""),"",IF(B8=C8,D7,IF(B8B8>C8,$B$2*-1+D7))))
D9	=IF(OR(B9="",C9=""),"",IF(B9=C9,D8,IF(B9B9>C9,$B$2*-1+D8))))
D10	=IF(OR(B10="",C10=""),"",IF(B10=C10,D9,IF(B10B10>C10,$B$2*-1+D9))))
D11	=IF(OR(B11="",C11=""),"",IF(B11=C11,D10,IF(B11B11>C11,$B$2*-1+D10))))
D12	=IF(OR(B12="",C12=""),"",IF(B12=C12,D11,IF(B12B12>C12,$B$2*-1+D11))))
D13	=IF(OR(B13="",C13=""),"",IF(B13=C13,D12,IF(B13B13>C13,$B$2*-1+D12))))
D14	=IF(OR(B14="",C14=""),"",IF(B14=C14,D13,IF(B14B14>C14,$B$2*-1+D13))))
D15	=IF(OR(B15="",C15=""),"",IF(B15=C15,D14,IF(B15B15>C15,$B$2*-1+D14))))
D16	=IF(OR(B16="",C16=""),"",IF(B16=C16,D15,IF(B16B16>C16,$B$2*-1+D15))))
D17	=IF(OR(B17="",C17=""),"",IF(B17=C17,D16,IF(B17B17>C17,$B$2*-1+D16))))
D18	=IF(OR(B18="",C18=""),"",IF(B18=C18,D17,IF(B18B18>C18,$B$2*-1+D17))))
D19	=IF(OR(B19="",C19=""),"",IF(B19=C19,D18,IF(B19B19>C19,$B$2*-1+D18))))
D20	=IF(OR(B20="",C20=""),"",IF(B20=C20,D19,IF(B20B20>C20,$B$2*-1+D19))))
D21	=IF(OR(B21="",C21=""),"",IF(B21=C21,D20,IF(B21B21>C21,$B$2*-1+D20))))