Hi there
This is my 1st post so I'll try and keep it short.

A few years ago now I had an excel spreadsheet with various tabs for football betting. I cannot remember what it was called but one of the tabs was for 3 selections with 1 banker and a fixed target profit amount. Another was for 4 selections with 2 bankers but this time a fixed stake amount.


Anyway... I have figured out how to do the latter, but am really struggling to do the 1st one.

eg. I have a banker selection and 2 other selections that I am confident won't lose... so I have 4 possible outcomes (bets)
1 1 1 for 3 straight wins
1 1 x for 2 wins and a draw
1 x 1
1 x x banker win and other 2 draw...
How can I set out my spreadsheet and what formula would I use to work out what each stake would be based on me wanting a total equal target profit amount on any of the 4 outcomes?

I hope that I have made this clear or if anyone reading this knows what spreadsheet I am talking about and what it was called.

Many thanks in advance

Dave