Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
COMBIN
COMBIN calculates how many ways you can choose k items from a set of n items when order does not matter (also written C(n,k) or nCk). It is used in probability, lottery odds, and experiment design. The result equals FACT(n) / (FACT(k) * FACT(n-k)).
Excel
=COMBIN(A2,B2)Google Sheets
=COMBIN(A2,B2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| n (Total) | k (Choose) | Combinations |
| 10 | 3 | |
| 6 | 2 | |
| 52 | 5 | |
| 8 | 4 |
=COMBIN(A2,B2)→120
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the total number of items n (e.g. 10 players).
- 2B2 is how many to choose k (e.g. 3 for a team of 3).
- 3COMBIN(10,3) = 120, meaning there are 120 ways to pick 3 players from 10.