COMBINA function
Summary
Returns the number of combinations with repetitions for a given number of items
Syntax
COMBINA(number, number_chosen)
The COMBINA function syntax has the following arguments.
• Number Required. Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated.
• Number_chosen Required. Must be greater than or equal to 0. Non-integer values are truncated.
• Number Required. Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated.
• Number_chosen Required. Must be greater than or equal to 0. Non-integer values are truncated.
Example
=COMBINA(4,3)
=COMBINA(10,3)
=COMBINA(10,3)