Spread.NET 17 Formula Reference
Formula Functions / Functions M to Q / PERMUTATIONA
In This Topic
    PERMUTATIONA
    In This Topic

    This function calculates the number of permutations for the specified number of items (along with repetitions) that can be selected from the total items.

    Syntax

    PERMUTATIONA(k,n)

    Arguments

    This function has the following arguments:

    Argument Description
    k Refers to the total number of items. This value must be greater than 0. If the specified value is not an integer, the number is truncated.
    n Refers to the number of items in each possible permutation. This value must be positive or 0. If the specified value is not an integer, the number is truncated.

    Remarks

    If the values in the arguments passed are invalid, this functions returns an error.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    PERMUTATIONA(4,6) gives the result 4096.

    PERMUTATIONA(2,5) gives the result 32.

    Version Available

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