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