Formula Functions > Functions A to C > COMBIN |
This function calculates the number of possible combinations for a specified number of items.
COMBIN(k,n)
This function has these arguments:
Argument | Description |
---|---|
k | Number representing the number of items; if not an integer, the number is truncated; must be positive and greater than or equal to n |
n | Number of items in each possible permutation; if not an integer, the number is truncated; must be positive |
A combination is any set or subset of items, regardless of the internal order of the items. Contrast with permutation (the PERMUT function).
The number of combinations is calculated as follows:
Accepts numeric data for both arguments. Returns numeric data.
COMBIN(C4,B2)
COMBIN(B3,5)
COMBIN(R1C2,2)
COMBIN(8,2) gives the result 28
COMBIN(100,3) gives the result 161700
This function is available in product version 1.0 or later.
PERMUT | Math and Trigonometry Functions