Hello All,
Thank you for this forum it is great. I have a bit of an issue creating a Game Calculator for my casino. Capture.PNG
Basically I am trying to get a formula for the "Middle Bet" how the game works is your pay out is based on the outcome of both M16 and N16 (whichever is greater) and the wager I20. I already have the payout information in X17:X27 but am trying to get the cell to see which ever is "Greater of an outcome" in M16 and N16 and then inputting that data from X17:X27
In the photo I have the formula that in my head would work but Excel is REALLY hating me for that formula.
The other wagers "Across Bet" and "Down Bet" is solved by =SUMPRODUCT(SUMIF($Q$17:$Q$27,$N$16,$W$17:$W$27)) but its just not liking trying to figure out the max of the 2 outcomes and putting that data in.
For anyone trying to understand the casino game I am talking about it is Criss Cross Poker.
If I can help clarify anything further please let me know.
Bookmarks