# Documentation/Calc Functions/COMBINA

Other languages:
dansk • ‎English

COMBINA

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).

• 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:

## 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

COMBIN

PERMUT

## ODF standard:

Section 6.16.17, part 2

COMBINA