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
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