Combine (Combination)

The number of possible combinations for a given number of items selected as a group from a set.

Syntax

Combine(Number, Number_Chosen)

Where:

Number is the number of items in a set.

Number_Chosen is the number of items to be included in each combination.

Expression

In the expression that follows, Number = n; Number_Chosen = k,

Where:

Usage Notes

In combination calculations, the internal order of the items selected does not affect the return. This differs from the case of a permutation, in which the order of the items selected does affect the return. Permutation is a statistical function.

If an argument is not an integer, it is truncated.

This function returns an error value if:

• Either argument is nonnumeric
• n< 0
• k < 0
• n £ k