Functions
COMBIN
Number of combinations without repetition
Try it
When to use it
When should I use COMBIN?
Use COMBIN to count how many ways you can choose k items from n items when order does not matter and repetition is not allowed.
Used in
Syntax
COMBIN(n, k)Examples
=COMBIN(4,2) // => 6
=COMBIN(10,3) // => 120
=COMBIN(5,0) // => 1