Thread: Set Profit

Originally Posted by bntre

Hi All,

I'm trying to work out a formula that gives me the amount I have to wager to win a set profit, if I know what the odds are. It also has to able to do this for each subsquent race if I should lose the race before.

I have been trying to work this out but have got myself confused.

regards

Sounds simple so probably more involved than it seems.

Does this work?

• Put your required profit in A1
• Put the odds in cells B1 and C1 (e.g 1:6 is 1 in B1 & 6 in C1, 2 to 1 on is 2 in B1 & 1 in C1, etc.)
• formula for wager required in D1 is =(A1/(C1/B1)

Remember, the only way to make money following horses is with a shovel.