Skip to main content

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:

 

Error.

User does not have sufficient privileges to access this Content
Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.