[gamblingisfun]

There are probably hundreds of excel related questions on here and Ive gone through a lot of them but I havent come across one that can help yet. I want to know what formula I would use if i wanted to find out how much I would bet to win a certain amount. I have the odds (-120 for example) in A1, the amount I'd like to win in B1(100 for example), and the amount I'd have to bet in cell C1. I just need that magical formula that tells me that I should be betting 120 to automatically pop up...

[paranoyd androyd]

the formula for Column C (To Bet) =A2*(B2/100)

example data:

Odds	To Win	To Bet
120	100	120
140	50	70
130	40	52
125	60	75
110	70	77

[paranoyd androyd]

^^ this was based on calculating betting amounts for -ML faves only.

this is a better universal formula if you want to know how much to bet for either -ML (faves) or +ML (dogs). you'll need to remember to enter a minus sign in front of your odds in column A for ML faves, otherwise the formula will treat column A as a ML dog.

cell C2 formula =IF(A2<0,-A2*(B2/100),(B2*100)/A2).. copy all the way down column C

sample data set..

odds	to win	to bet
-110	100	110
-120	150	180
-130	80	104
-135	60	81
110	110	100
120	60	50
125	85	68
130	65	50

[gamblingisfun]

Thank you. It worked perfectly.