COMBINA function

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.

Notes

How to apply the COMBINA function.

Examples

The figure below displays the result returned by the COMBINA function.