Documentation/Calc Functions/PERMUT

Function name:
PERMUT

Category:
Statistical Analysis

Summary:
Returns the number of permutations for a given number of objects. This function should be used in situations involving the selection of a subset from a set of objects (without repetition), with the selected objects arranged in a particular order.

Syntax:
PERMUT(Count1; Count2)

Returns:
Returns a positive integer which is the number of permutations of Count2 objects taken from Count1 objects.

Arguments:
Count1 is an integer value or a reference to the cell containing that value which is the total number of objects.

Count2 is an integer value or a reference to the cell containing that value which is the number of objects in each permutation.


 * If either Count1 or Count2 is negative or Count1 is smaller than Count2 then the function returns an error value.
 * If Count1 or Count2 are non-integer value then they are truncated to integers.

Additional details:

 * The formula for PERMUT is:

where n is Count1 and k is Count2.
 * For more details on permutation, visit Wikipedia.

Related LibreOffice functions:
COMBIN

COMBINA

PERMUTATIONA

ODF standard:
Section 6.18.59, part 2

Equivalent Excel functions:
PERMUT