Author: Oscar Cronquist Article last 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:

=COMBIN(3,2)

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.