Documentation/Calc Functions/COMBIN
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
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:
ODF standard:
Equivalent Excel functions:
COMBIN