COMBIN

Definition of COMBIN

Returns the number of ways to choose some number of objects from a pool of a given size of objects.

Sample Usage

COMBIN(4,2)

COMBIN(A2,B2)

Syntax

COMBIN(n, k)

• n - The size of the pool of objects to choose from.

• k - The number of objects to choose.

Notes

• COMBIN is the standard combinatorics function typically notated nCk and read "n choose k". This is equivalent to FACT(n)/(FACT(k)*FACT(n-k)).

See Also

MULTINOMIAL: Returns the factorial of the sum of values divided by the product of the values' factorials.

FACTDOUBLE: Returns the "double factorial" of a number.

FACT: Returns the factorial of a number.

To use the COMBIN Formula, simply begin with your edited Excellentable:

Then begin typing the COMBIN formula in the area you would like to display the outcome: 

By adding the values you would like to calculate, Excellentable generates the outcome: