WorksheetFunction.Combin Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the number of combinations for a given number of items. Use Combin to determine the total possible number of groups for a given number of items.

expression .Combin(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

Double

The number of items.

Arg2

Required

Double

The number of items in each combination.

Return Value

Double

  • Numeric arguments are truncated to integers.

  • If either argument is nonnumeric, Combin generates an error.

  • If number < 0, number_chosen < 0, or number < number_chosen, Combin generates an error.

  • 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 number = n and number_chosen = k: awfcmbn1_ZA06051122where: awfcmbn2_ZA06051123

Show: