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.
Syntax:
Combin(p, q)
Return data type: integer
Limitations:
Non-integer items 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 |