COMBINA

  • Updated

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.