Export (0) Print
Expand All
Expand Minimize

WorksheetFunction.Combin Method (Excel)

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:
© 2014 Microsoft