Combina Function in Excel 2013

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.

Step 1

First go to Excel 2013.

Step 2

Now select a blank workbook template from the available templates.

combina-function-in-excel2013.jpg

Step 3

Now write the following data.

excel2013-combina-function.jpg

Step 4

Now write the following function to determine the number of combinations with repetitions for the above given numbers.

use-of-combina-function-in-excel2013.jpg

Step 5

The output will be like this.

 excel2013-with-combina-function.jpg


Similar Articles