The COMBINA function is one of the math and trigonometry functions. It is used to return the number of combinations (with repetitions) for a given number of items.
Syntax
COMBINA(number, number_chosen)
The COMBINA function has the following arguments:
Argument
Description
number
The total number of items, a numeric value greater than or equal to 0.
number_chosen
A number of items in a combination, a numeric value greater than or equal to 0 but less than number.