Math and Trignometric - COMBINA Function

Description

The COMBINA function returns the number of combinations (with repetitions) for a given number of items.

COMBINA (number, number_chosen)

Argument	Description	Required/Optional
Number	Must be greater than or equal to 0, and greater than or equal to Number_chosen. Non-integer values are truncated.	Required
Number_chosen	Must be greater than or equal to 0. Non-integer values are truncated.	Required

Argument

Description

Required/Optional

Number

Must be greater than or equal to 0, and greater than or equal to Number_chosen.

Non-integer values are truncated.

Required

Number_chosen

Must be greater than or equal to 0.

Non-integer values are truncated.

Required

The following equation is used −

$$\binom{N+M-1}{N-1}$$

Where, N is Number and M is Number_chosen.
If the value of either argument is outside of its constraints, COMBINA returns the #NUM! error value.
If either argument is a non-numeric value, COMBINA returns the #VALUE! error value.

Excel 2013, Excel 2016

advanced_excel_math_trigonometric_functions.htm