Documentation/Calc Functions/COMBINA

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

COMBINA

Category:

Mathematical

Summary:

Returns the number of combinations of a subset of items including repetitions.

Syntax:

COMBINA(Count 1; Count 2)

Returns:

Returns a positive integer.

Arguments:

Count 1 is the positive number of items in the set, or a reference to a cell containing the number.

Count 2 is the positive number of items to choose from the set, or a reference to a cell containing the number.

  • Arguments are truncated to integers, i.e. if either argument is nonnumeric, floor value of the argument is used.
  • If Count 1 < 0, Count 2 < 0, or Count 1 < Count 2, COMBINA returns an error value (Err:502).

Additional details:

  • A combination is any set or subset of items, regardless of their internal order. Combinations are distinct from permutations, for which the internal order is significant.
  • The number of combinations is as follows, where Count 1 = N and Count 2 = M:
Combina.png

Examples:

Formula Description Returns
=COMBINA(7;3) from a group of 7 items, 3 can be chosen with repetitions in 84 ways 84
=COMBINA(7.6;3) from a group of 7 items(floor value is taken), 3 can be chosen with repetitions in 84 ways 84
=COMBINA(11;-2) can not choose negative number of items Err:502
=COMBINA(11;14) can not choose more number of items than the total count Err:502


Related LibreOffice functions:

COMBIN

PERMUT

ODF standard:

Section 6.16.17, part 2

Equivalent Excel functions:

COMBINA