Combin

Syntax

Combin(SetSize, SampleSize)

Parameters

SetSize. Total number of elements in the set. Available values are in the (0, ∞) range.

SampleSize. The number of elements to select from the set. Available values are in the (0, SetSize] range.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It returns the number of combinations for the specified number of objects.

Comments

A combination is any set or a subset of objects, regardless of their order. Combinations differ from permutations, for which order is relevant.

Example

Formula Result Description
=Combin(B6, C1) 15 The number of objects is defined in the B6 cell, while the number of objects in each combination is specified in the C1 cell. The B6 cell contains the 15 number, while the C1 cell contains the 1 number.
=Combin(8, 2) 24 Teams consisting of two people are possible, which can be formed from eight candidates.

See also:

Function Wizard │ Mathematical Functions