EXCEL COMBINA FUNCTION

The Excel Combina function computes the number of combinations of a specified number of items from a set, using repeats.

Syntax:

=COMBINA( numbernumber_chosen )

Parameter:

  • The following are the arguments:

number:

  • The set’s number of objects (must be 0).

number_chosen: 

  • The number of objects from the set to be picked (must be 0).

Step By Step Guide of COMBINA Function

Example :

There are 21 possible combinations (with repeats) of two things for any six objects (e.g. a, b, c, d, e, f). They are as follows:
aa ab ac ad ae af bb bc bd be bf cc cd ce cf dd de df ee ef ff
This computation is presented in cell A2 of the sample spreadsheet below.
The spreadsheet example below also illustrates how to use the Combina function to determine the number of combinations (with repeats) for different numbers of objects from a set of six.

  • #NUM! – Occurs if either the given number or the number chosen argument is less than zero.
  • #VALUE! – Occurs if either of the supplied arguments is not a number.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now