# Documentation/Calc Functions/COMBIN

Other languages:
dansk • ‎English

COMBIN

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)

• 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

COMBINA

PERMUT

## ODF standard:

Section 6.16.16, part 2

COMBIN