Skip to main content

Combin

ON THIS PAGE

Combin

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

See also