Documentation/Calc Functions/PERMUTATIONA

From The Document Foundation Wiki
Jump to navigation Jump to search


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.

Examples:

Formula Description Returns
=PERMUTATIONA(7;3) From a group of 7 items, a sequence of 3 can be picked in 343 ways with repetition allowed. 343
=PERMUTATIONA(7.6;3) From a group of 7 items (floor value is taken), a sequence of 3 can be picked distinctly in 343 ways with repetition allowed. 343
=PERMUTATIONA(0;0) From a group of 0 items, a sequence of 0 can be picked in only 1 way. 1
=PERMUTATIONA(11;-2) Cannot pick a negative number of items hence the function returns an error value. Err:502
=PERMUTATIONA(11;14) This function allows the case where Count1 is smaller than Count2. 379749833583241

Related LibreOffice functions:

COMBIN

PERMUT

ODF standard:

Section 6.18.60, part 2

Equivalent Excel functions:

PERMUTATIONA