COMBIN

Returns the number of combinations of n unlike things taken k at a time.

Syntax:

COMBIN(n:number, k:number)

This function yields the number of combinations of n unlike things taken k at a time.

The formula used is:

nCk = n! ÷ ((n - k)! × k!)

For very large n this is an approximation achieved using logarithms.