Please note javascript is required for full website functionality.
MVP

Blog

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.

Please see my example below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.

A full page of the function articles can be found here. 

Newsletter