COMBINA function
Description
COMBINA(number,number_chosen) returns the number of combinations (with repetitions) of a number of items, where number_chosen is number of items in each combination, i.e. returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways to choose the same object multiple times (also known as choosing with replacement).
The number of combinations with replacement, where number = n and number_chosen = k, is:
$$ \binom{n+k-1}{k} = \frac{(n+k-1)!}{k!(n-1)!} $$
- Numeric arguments are truncated to integers.
- The arguments cannot be negative.