﻿ COMBINA | Spread.NET 15 Formula Reference
Formula Functions / Functions A to C / COMBINA
In This Topic
COMBINA
In This Topic

This function calculates the number of possible combinations (along with repetitions) for the specified number of items.

#### Syntax

COMBINA(Value, Value_chosen)

#### Arguments

This function has the following arguments:

Argument Description
Value Refers to the number representing the number of items. This value must be positive and greater than or equal to the second argument i.e. Value_chosen.
Value_chosen Refers to the number of items in each possible combination. This value must be positive.

#### Remarks

The following equation is used to calculate the COMBINA function:

(Value + Value_chosen -1) / (Value-1)

#### Data Types

Accepts numeric data for both arguments. Returns numeric data.

#### Examples

COMBINA(5,4) gives the result 70.

COMBINA(6,5) gives the result 252.

COMBINA(11,3) gives the result 286.

#### Version Available

This function is available in Spread for Windows Forms 11.0 or later.