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.