COMBIN

The COMBIN function 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: The FACT function returns the factorial of a number.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Main menu
16493996280629279386
true
Search Help Center
true
true
true
true
true
35
false
false