Returns the number of combinations for the specified number of items.
Syntax
 Copy Code
|
|---|
COMBIN( Integer n, Integer k ) → Integer |
Parameters
- n
- Required. The total number of objects. Must be a positive number.
- k
- Required. The number of objects in each combination. Must be a positive number.
Remarks
A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations, for which the internal order is significant. The number of combinations is n!/k!/(n-k)! where ! denotes factorial.
If n is less than k, or either n or k are negative or zero, the function returns the #NUM! error value.
Example
| Formula
Copy Code
|
|---|
=COMBIN(49,6) |
See Also
Function Reference
FACT Function
PERMUT Function