# 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