The COMBIN function returns the number of combinations without repetition of a set of elements grouped in blocks of a certain size.
COMBIN(
number,
number_chosen
)
- number: Number of elements to group.
- number_chosen: Number of elements considered in each combination.
The COMBIN function returns an integer.
If the number or number_chosen arguments are not integers, they will be rounded to the nearest integer. If they are not numbers or are negative numbers, the function will return an error (both arguments can be 0, in which case the result will be 1). number must be greater than or equal to number_chosen. Otherwise an error message will be returned.
A combination of N elements grouped in blocks of K elements without repetition is a subset of K elements, all different, in which their order is not taken into account.
The number of combinations of 4 elements (A, B, C, D) grouped in blocks of 3 without repetition is 3:
- A, B, C
- A, B, D
- A, C, D
- B, C, D