Please note javascript is required for full website functionality.

# A to Z of Excel Functions: the COMBINA Function

4 September 2017

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the COMBINA function.

The COMBINA function

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

The COMBINA function employs the following syntax to operate:

COMBINA(number, number_chosen)

The COMBINA function 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.

It should be further noted that:

• 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.
• The following equation is used:
• In the equation above, N is Number and M is Number_chosen.