Documentation/Calc Functions/COMBIN

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

COMBIN

Category:

Mathematical

Summary:

Returns the number of combinations for elements without repetition. It is used to determine the total possible number of groups for a given number of items.

Syntax:

COMBIN(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, COMBIN 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 = R:
Combin.png

Examples:

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

Related LibreOffice functions:

COMBINA

PERMUT

ODF standard:

Section 6.16.16, part 2

Equivalent Excel functions:

COMBIN