COMBINA

Returns the number of combinations (including repetitions) for a given number of objects.

Sample Usage

COMBINA(10,5)
COMBINA(A4,A5)

Syntax

COMBINA(number1, number2)

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

Examples

COMBINA(10,5) returns a value of 2002.
COMBINA(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, COMBINA returns the #NUM! error value.
• If either argument is a non-numeric value, COMBINA returns the #VALUE! error value.