This is a new function introduced in Excel 2013. This function is used to return the number of combinations with repetitions for a given number of items. The syntax of the Combina method is as follows: =COMBINA(number,number_chosen). In this way the Combina function takes two arguments; one is a number which should be greater than or equal to 0 and the other is number_chosen which should be also be greater than or equal to 0. For example: =combina(6,7) returns the number of combinations with repetitions for 6 and 7 i.e. 792.
Lets have a look at the following steps.
First go to Excel 2013.
Now select a blank workbook template from the available templates.
Now write the following data.
Now write the following function to determine the number of combinations with repetitions for the above given numbers.
The output will be like this.