Spread.NET 18 Formula Reference
Formula Functions / Functions M to Q / PERMUT
In This Topic
    PERMUT
    In This Topic

    This function returns the number of possible permutations for a specified number of items.

    Syntax

    PERMUT(k,n)

    Arguments

    This function has these arguments:

    Argument Description
    k Number of items; must be greater than 0; if not an integer, the number is truncated
    n Number of items in each possible permutation; must be positive or 0; if not an integer, the number is truncated

    Remarks

    A permutation is any set or subset of items where internal order is significant. Contrast with combinations (the COMBIN function).

    The equation for this function is:

    PERMUT Equation

    where k and n are defined in the arguments.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    PERMUT(B3,5)

    PERMUT(C4,B2)

    PERMUT(R1C2,2)

    PERMUT(8,2) gives the result 56

    PERMUT(100,3) gives the result 970200

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    COMBIN | Math and Trigonometry Functions