Quote:
Originally Posted by steel108
I have spent the past few hours on this with no luck. I have very basic knowledge of Excel so that might be the problem. Here is what I am trying to figure out.... it's a poker simulation, but has applications to other fields.
I have $1,000
the pot is $150
There are 3 betting opportunities to bet
What is the least amount I can bet on the first and second betting opportunities so that the money I have will = the pot on the final betting opportunity.
An example:
if I bet 80 on the first opportunity, I will have 920 left and the pot will be 310
if I bet 200 on the second opportunity, I will have 720 left and the pot will be 710.
This is almost correct, but I have 10 more than the pot on the last betting opportunity.
I need a function that is dynamic since the pot and amount to bet will vary depending on the situation. If I want to run a query on 420 left with a pot of 80, the results should be adapted. I have tried doing this without functions, but I just can't it work for a wide set of variables (pot size and money left are the 2 variables with the betting sizes being the output)
Thanks for any advice you can give.
Is there a function that will achieve what I need?
|
You will need more than one formula in more than one cell.
Starting money= 1000
Starting Pot= 150
Bet one= (blank)
Bet two=(blank)
Bet three=(blank)
Current Money=sum(starting money-(bet one+bet two+bet three))
Current bet=sum(starting pot+(bet one+bet two+bet three))
Max bet to equal pot=sum((current money-current pot)/2)
in these formulas, the labels (starting money, bet one, bet two, ...) are cell numbers containing that info.
Let me know how it works for you.
TD