# EXCEL FUNCTIONS-COMBIN

## INTRODUCTION

COMBIN function comes under the MATH AND TRIG category in Excel.

COMBIN function returns the number of possible combinations with the specified number of items.

COMBIN function performs the calculation based on the COMBINATION concept of MATHEMATICS.

LET US UNDERSTAND THE COMBINATION CONCEPT FIRST.

Suppose , there are three different persons and we need to create a group of two persons.

Now if we need to find out ,in how many ways two out of three persons can be chosen to make a group of two.

Suppose there are three persons

A,B and C.

So different groups can be

AB

AC

BC

i.e. There can be three groups.

In Mathematics the direct formula for the same calculation is

nCr where n is the number of items. r is the size of group.

nCr is elaborated as n!/(n-r)!r!

where n!=nx n-1 x n-2 x n-3x ….1

Now , let us put the above mentioned example into the formula.

In the above example

n=3

r=2

so Number of combinations= 3!/2!1!

=3×2/2

=3

which is exactly same result what we got when we tried to calculate the same manually.

## PURPOSE OF COMBIN FUNCTION IN EXCEL

COMBIN function returns the number of possible combinations with the specified number of items.

## PREREQUISITES TO LEARN COMBIN

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

•  Basic understanding of how to use a formula or function.
•  Basic understanding of rows and columns in Excel.
• Some information about the financial terms is an advantage for the use of such formulas.
•  Of course, Excel software.

Helpful links for the prerequisites mentioned aboveWhat Excel does? How to use formula in Excel?

## SYNTAX: COMBIN FUNCTION

The Syntax for the function is

=COMBIN(NUMBER OF ITEMS, NUMBER OF ITEMS IN SUBGROUP)NUMBER OF ITEMS Number of total itemsNUMBER OF ITEMS IN SUBGROUP Number of items which are to be chosen from the total items

## EXAMPLE:COMBIN FUNCTION IN EXCEL

### DATA SAMPLE

We will try to find out the different combination possible for two cases involving 3 numbers and 4 numbers and selecting

2 numbers from the group.

The analysis is done manually as well as using the COMBIN function.

### STEPS TO USE COMBIN FUNCTION

To demonstrate the usage of the function in different ways, we have taken two examples which have 3 and 4 numbers respectively.

The groups are to be formed of 2 numbers each.

In manual examples, the grouping has been done manually and the groups are shown in the rows.

The same groups are put for testing under the function COMBIN.

The function used is

=COMBIN(3,2) and =COMBIN(4,2).

First case has 3 numbers and 2 is the size of the group.

Second case has 4 numbers and 2 is the size of the group.

which gives the same result as the manual cases.

## KNOWLEDGE BYTES

### COMBINATION USING COMBIN FUNCTION

PERMUTATION AND COMBINATION , you must be acquainted with this word in higher mathematics.

We calculate the permutations for the different possible arrangements of the given number of items. It is calculated by

n!/(n-r)!.

where n!= n x n-1 x n-2 x…..1

So, when we need to make groups, we need not take into consideration, the number of permutations between the same number of selection as  AB and BA are same when we talk about combination.

So for combination the formula is converted into

n!/(n-r)!.r!