Calculate Liability

[dgavin]

A B C D
1 ODDS COMM STAKE LIABILITY
2 4.00 5% 10.00 £30.15
3 4.50 5% 8.56 £30.14

Liability = ((ODDS-1)*(COMM+STAKE))

I need help with a formula that can calculate C3 by matching the liability.

So if I enter odds and stake in row 2 my formula will calculate the liability.

If I enter odds in row 3, i need a formula to match liability in D2 and also what stake (C3) is required.

Many Thanks

 

[Andrew Poulsom]

If:

Liability = (Odds-1)*(Comm+Stake)

then:

Odds = (Liability/(Comm+Stake))+1
Stake = (Liability/(Odds-1))-Comm

So if you have Odds, Comm and Stake in row 2, Liablility is:

=(A2-1)*(B2+C2)

If you have Comm, Stake and Liability, Odds is:

=(D2/(B2+C2))+1

If you have Odds, Comm and Liability, Stake is:

=(D2/(A2-1))-B2