Excel Formula Assistance

[TRD]

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

[TRD]

Bigbroben?

[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.

[Bigbroben]

Or did you just want a math formula?

[Buffster]

Have you considered using AI for help with your formulas. I use ChatGPT and it gives me all my formulas for my sheets.

Buffster

[Bigbroben]

Natural Intelligence is normally included in one's brain.  It should allow most ppl to solve this simple math problem.