Formula that maintains a persistent profit margin

[Nivra_G]

Hi guys,

World cup is around the corner and i'd like to do up a spreadsheet that highlights a persistent profit margin. I've done up a basic version of this. But i'd like there to be a column that highlights how much extra we will need to put in if we wanted the payout for each outcome to be $800. Simple version below.

[TABLE="width: 839"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]MINIMUM[/TD]
[TD]TARGET AMOUNT:[/TD]
[TD="align: right"]$800[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Players[/TD]
[TD="align: right"]ODDs
[/TD]
[TD="align: right"]Your Bet Amount[/TD]
[TD="align: right"]Your Win Amount[/TD]
[TD="align: right"]Your Profit[/TD]
[TD="align: right"]Min BET to Target[/TD]
[TD="align: right"]Min Target Profit[/TD]
[/TR]
[TR]
[TD]Harry Kane[/TD]
[TD="align: right"]$15[/TD]
[TD="align: right"]$20[/TD]
[TD="align: right"]$300[/TD]
[TD="align: right"]$178[/TD]
[TD="align: right"]$53[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Luis Suarez[/TD]
[TD="align: right"]$21[/TD]
[TD="align: right"]$25[/TD]
[TD="align: right"]$525[/TD]
[TD="align: right"]$525[/TD]
[TD="align: right"]$38[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Higuain[/TD]
[TD="align: right"]$26[/TD]
[TD="align: right"]$15[/TD]
[TD="align: right"]$390[/TD]
[TD="align: right"]$390[/TD]
[TD="align: right"]$31[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Timo Werner[/TD]
[TD="align: right"]$15[/TD]
[TD="align: right"]$22[/TD]
[TD="align: right"]$330[/TD]
[TD="align: right"]$330[/TD]
[TD="align: right"]$53[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Muller[/TD]
[TD="align: right"]$34[/TD]
[TD="align: right"]$20[/TD]
[TD="align: right"]$680[/TD]
[TD="align: right"]$680[/TD]
[TD="align: right"]$24[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Griezmann[/TD]
[TD="align: right"]$11[/TD]
[TD="align: right"]$20[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]$220[/TD]
[TD="align: right"]$73[/TD]
[TD="align: right"]$528[/TD]
[/TR]
[TR]
[TD]Totals[/TD]
[TD][/TD]
[TD="align: right"]$122[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$272[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


MIN Bet Profit is currently the Bet amount multiplied by the odds deducted by the total "Min BET to target" (Capital).

Would there be a way to ensure the Bet Profit is constantly $800 for each outcome?

 

[Oscar Cronquist]

Would there be a way to ensure the Bet Profit is constantly $800 for each outcome?

I still don't get it, how is that calculated?

 

[mikerickson]

If the word "Odds" is in B2 then a formula like =800/B3 should return the bet that would result in an $800 win at the odds in B3