The COMBINE function returns the number of combinations with repetition of a set of elements grouped in blocks of a certain size.
COMBINA(
number,
number_chosen
)
- number: Number of elements to group.
- number_chosen: Number of elements considered in each combination.
The COMBINE 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 of the function will be 1). number can be less than number_chosen (remember that these are combinations with repetition).
A combination of N elements grouped in blocks of K elements with repetition is a subset of K elements, which may be repeated, 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 with repetition is 20:
- A, A, A
- A, A, B
- A, A, C
- A, A, D
- A, B, B
- A, B, C
- A, B, D
- A, C, C
- A, C, D
- A, D, D
- B, B, B
- B, B, C
- B, B, D
- B, C, C
- B C D
- B, D, D
- C, C, C
- C, C, D
- C, D, D
- D, D, D