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 arguments will be truncated.
Examples and results:
- How many combinations of 7 numbers can be picked from a total of 35 lottery numbers?
Combin( 35,7 ) returns 6,724,520
