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...
-
-
the formula for Column C (To Bet) =A2*(B2/100)
example data:
<table border="0" cellpadding="0" cellspacing="0" width="192"><tbody><tr style="height:12.75pt" height="17"><td class="xl22" style="height:12.75pt;width:48pt" height="17" width="64">Odds</td> <td class="xl22" style="width:48pt" width="64">To Win</td> <td class="xl22" style="width:48pt" width="64">To Bet</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17"> 120</td> <td class="xl22"> 100</td> <td class="xl22"> 120</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17"> 140</td> <td class="xl22"> 50</td> <td class="xl22"> 70</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17"> 130</td> <td class="xl22"> 40</td> <td class="xl22"> 52</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17"> 125</td> <td class="xl22"> 60</td> <td class="xl22"> 75</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl22" style="height:12.75pt" height="17"> 110</td> <td class="xl22"> 70</td> <td class="xl22"> 77</td> </tr> </tbody></table>Comment -
^^ 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..
<table border="0" cellpadding="0" cellspacing="0" width="192"><colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt;width:48pt" height="17" width="64">odds</td> <td class="xl24" style="width:48pt" width="64">to win</td> <td class="xl24" style="width:48pt" width="64">to bet</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">-110</td> <td class="xl24">100</td> <td class="xl24">110</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">-120</td> <td class="xl24">150</td> <td class="xl24">180</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">-130</td> <td class="xl24">80</td> <td class="xl24">104</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">-135</td> <td class="xl24">60</td> <td class="xl24">81</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">110</td> <td class="xl24">110</td> <td class="xl24">100</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">120</td> <td class="xl24">60</td> <td class="xl24">50</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">125</td> <td class="xl24">85</td> <td class="xl24">68</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" height="17">130</td> <td class="xl24">65</td> <td class="xl24">50</td> </tr> </tbody></table>Comment -
Thank you. It worked perfectly.Comment