Formula for specific profit

[Manic]

Hi all,

Could anyone help me with an excel formula?

I simply want to automate the amount to bet to reach a specific profit, and the stake factor is messing me around.

So for instance, if odds were 4.0 and I wanted to make $10, what would the formula be to tell excel what the correct stake would be.

Thanks for any help

[Captain Sensible]

Remember decimal odds always include the stake so 4.0 is also 3 to 1 (3/1)

If you wanted to win $10 the formula for the stake would be 10 divided by 3/1 = 3.33

If our target stake is in A1 ($10) and our current decimal odds in A2 (4.0) the excel formula would be

stake = A1/(A2-1)

[Manic]

Remember decimal odds always include the stake so 4.0 is also 3 to 1 (3/1)

Yeah that's the bit that I couldn't formulate.

Ahh the brackets and -1 needed to be added.

You're a legend Sir, thank you.