Google Sheets
COMBIN function in Google Sheets
Returns the number of ways to choose some number of objects from a pool of a given size of objects.
=COMBIN(n, k)COMBIN syntax and parameters
Two arguments, two required.
- nnumberRequired
The size of the pool of objects to choose from.
- knumberRequired
The number of objects to choose.
COMBIN examples
Formulas you'll actually reuse.
Head-to-head matches among B2 teams:
=COMBIN(B2, 2)Result
45Lottery odds — ways to pick 6 numbers out of 49:
=COMBIN(49, 6)Result
13983816
COMBIN in Excel
Same name — your formula ports as-is.
Try COMBIN in the playground
Edit the example — nothing to install.
Preloaded with the COMBIN formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ABSReturns the absolute value of a number.MathExcel
- ACOSReturns the inverse cosine of a value, in radians.MathExcel
- ACOSHReturns the inverse hyperbolic cosine of a number.MathExcel
- ACOTReturns the inverse cotangent of a value, in radians. .MathExcel
- ACOTHReturns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive..MathExcel
- ASINReturns the inverse sine of a value, in radians.MathExcel