This is a little tricky and I don't know if it can be done. I'm trying to
accomplish a few things. First, on Sheet 2, after putting odds in cells B3
& B4 (ex: +150 and +160), it will show how much needs to be bet in D4
(based on $25 bet on the lower odds in D3), same total profit that will be made
in F3 or F4, and the percentage of profit vs total risk (D3 + D4). Is there
some sort of way to "reverse" this. In other words, is there a way to reverse
the formulas in D4, F3, and F4 if you enter a percentage in J3 first. It would have to create values in B3, B4, D4 and create the same values in F3 & F4.
Basically, instead of imputing odds and the spreadsheet shows me the total risk (D3 + D4) vs Total Profit (F3/F4) and what the win vs risk % is, I want to do the reverse and input a percentage and have it work out the odds, bet in D4 and Total Profits in F3/F4.
Hopefully you understand. Sorry if this sounds confusing. Thanks.
Here is the spreadsheet:
https://www.dropbox.com/s/evhdzu3nbszzxto/One_Run_Games.xls?dl=0
accomplish a few things. First, on Sheet 2, after putting odds in cells B3
& B4 (ex: +150 and +160), it will show how much needs to be bet in D4
(based on $25 bet on the lower odds in D3), same total profit that will be made
in F3 or F4, and the percentage of profit vs total risk (D3 + D4). Is there
some sort of way to "reverse" this. In other words, is there a way to reverse
the formulas in D4, F3, and F4 if you enter a percentage in J3 first. It would have to create values in B3, B4, D4 and create the same values in F3 & F4.
Basically, instead of imputing odds and the spreadsheet shows me the total risk (D3 + D4) vs Total Profit (F3/F4) and what the win vs risk % is, I want to do the reverse and input a percentage and have it work out the odds, bet in D4 and Total Profits in F3/F4.
Hopefully you understand. Sorry if this sounds confusing. Thanks.
Here is the spreadsheet:
https://www.dropbox.com/s/evhdzu3nbszzxto/One_Run_Games.xls?dl=0
