Wonder if anyone is capable of setting the set of these 4 formulas up?
i.stack.imgur.com/bKmIn.jpg
Sheet is attached for quick access.Formula Set, 4x.xlsx
Bigbroben?
This?
I think this is what you meant?
Enter values in the blue cells.
Enter 18 nrs if playing ECs, 12 with Dozs, etc.
Tell me if something is not right.
A random play appears if there is no input in Column H. Enter 1 for a win, 0 for a loss.
It auto starts at step 1 on a win.
Or did you just want a math formula?
Have you considered using AI for help with your formulas. I use ChatGPT and it gives me all my formulas for my sheets.
Buffster
Natural Intelligence is normally included in one's brain. It should allow most ppl to solve this simple math problem.