Scroll To Top
Reader Level:
Article
Microsoft Office

Combina Function in Excel 2013

By Megha Goyal on Oct 18, 2012
In this article we will discuss how to use the 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