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 |
Learn more
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!