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