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.

	MINIMUM	TARGET AMOUNT:	$800
Players	ODDs	Your Bet Amount	Your Win Amount	Your Profit	Min BET to Target	Min Target Profit
Harry Kane	$15	$20	$300	$178	$53	$528
Luis Suarez	$21	$25	$525	$525	$38	$528
Higuain	$26	$15	$390	$390	$31	$528
Timo Werner	$15	$22	$330	$330	$53	$528
Muller	$34	$20	$680	$680	$24	$528
Griezmann	$11	$20	$220	$220	$73	$528
Totals		$122			$272

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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