SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / 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.

    See Also