Hi All,
New to this forum. I am looking for a way to do goalseek on an array/multiple cells.
I am creating a spreadsheet to calculate optimal bet sizes. I have a combination matrix with 2 independent events (Team 1 Wins/Team 1 Loses, and Player 1 Scores/Player 1 Doesn't score. Each of the events have odds assigned to them. Then I have an input table with bet sizes on each of the events.
Bet Sizes Team 1 wins 10 Team 1 doesn't win 10 Player 1 scores 10 Player 1 doesn't score 10
Odds Team 1 wins 3 Team 1 doesn't win 1.2 Player 1 scores 10 Player 1 doesn't score 1.1
Payout table Team 1 wins Team 1 doesn't win Player 1 scores 10 4 Player 1 doesn't score 12 -8
What I am looking to do is to alter the bet sizes, in a way that would make payouts equal under all possible outcomes. The numbers are just for illustration pusposes.
Does anyone know of a way of doing this?
Thanks
Bookmarks