Round Robin Formula

[kilmerAsHolliday]

Maybe somebody can help me count the number of bets in a RR. ie 7X2=21 7X3=35
My google machine wasn't able to help me find the formula

[x2]

(n!/(n-k)!)/k!

Here's the excel if you include the number of games in A1 and number of teams in A2

=(FACT(A1)/(FACT(A1-A2)))/FACT(A2)

[kilmerAsHolliday]

Thanks for the help, works great.

[lumpy19]

You can also just type 7 choose 3 into google, 8 choose 3, 7 choose 4, etc

[RickySteve]

(n!/(n-k)!)/k!

Here's the excel if you include the number of games in A1 and number of teams in A2

=(FACT(A1)/(FACT(A1-A2)))/FACT(A2)

Um, =COMBIN().

[kilmerAsHolliday]

I haven't used xl 5 years. I needed the formula.

[x2]

Um, =COMBIN().

Thanks. I shudder at the amount of similar overcomplication buried in my spreadsheets.

[brewers7]

Maybe somebody can help me count the number of bets in a RR. ie 7X2=21 7X3=35
My google machine wasn't able to help me find the formula

How about a Round-Robin and Parlay Excel spreadsheet where you plug in the amount bet and the moneyline amounts to see how much you win?...

Attached...