Documentation/Calc Functions/PERMUTATIONA

Function name:
PERMUTATIONA

Category:
Statistical Analysis

Summary:
Calculates the number of permutations containing a chosen number of objects out of a given total number of objects, with repetition permitted.

Syntax:
PERMUTATIONA(Count1; Count2)

Returns:
Returns a positive integer which is the number of permutations for a chosen number of objects, Count2, out of the total number of objects, Count1 where repetition is allowed.

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 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 PERMUTATIONA is: Count1Count2
 * Unlike PERMUT, which doesn't allow Count2 greater than Count1, PERMUTATIONA allows this case and returns a value calculated using the above formula.
 * For more details on permutation with repetition, visit Wikipedia.

Related LibreOffice functions:
COMBIN

COMBINA

PERMUT

ODF standard:
Section 6.18.60, part 2

Equivalent Excel functions:
PERMUTATIONA