COMBIN

Returns the number of combinations for a given number of objects.

Sample Usage

COMBIN(10,5)
COMBIN(A4,A5)

Syntax

COMBIN(number1, number2)

  • number1 - The total number of objects.
  • number2 - The number of objects to choose.

 

Examples

COMBIN(10,5) returns a value of 252.
COMBIN(A4,A5) returns the number of combinations (with repetitions) for numbers A4 and A5.

Notes

  • number1 and number2 must be greater than or equal to zero.
  • number1 must be greater than or equal to number2.
  • If the value of either argument is outside of its constraints, COMBIN returns the #NUM! error value.
  • If either argument is a non-numeric value, COMBIN returns the #VALUE! error value.