## How to use the COMBIN function

*Article updated on March 29, 2018*

The COMBIN function returns the number of combinations for a specific number of elements out of a larger number of elements.

Formula in cell F3:

Column B, C and D demonstrate how many combinations there are when 2 elements are selected out of 3 elements [A, B, C].

The three combinations are [A,B] ,[A,C] and [B,C]. The elements internal order is not important, that is why [A,B] and [B,A] is the same combination.

### Excel Function Syntax

COMBIN(*number*, *number_chosen*)

### Arguments

number |
Required. A whole number larger than 0 (zero) that represents the total number of elements. |

number_chosen |
Required. A whole number larger than 0 (zero) that represents the number of elements in each combination. |

### Comments

I recommend you click on the following link if you want to read about the difference between combinations and permutations in greater detail.

### Functions in 'Math and trigonometry'

The COMBIN function function is one of many functions in the 'Math and trigonometry' category.