Combin() returns the number of combinations of q elements that can be picked from a set of p items. As represented by the formula: Combin(p,q) = p! / q!(p-q)! The order in which the items are selected is insignificant.


Combin(p, q)

Return data type: integer


Non-integer arguments will be truncated.

Examples and results:  

Examples Results

How many combinations of 7 numbers can be picked from a total of 35 lottery numbers?

Combin( 35,7 )

Returns 6,724,520

See also: