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:
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.