Documentation/Calc Functions/PERMUT

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Permut new.png

where n is Count1 and k is Count2.

  • For more details on permutation, visit Wikipedia.

Examples:

Formula Description Returns
=PERMUT(7;3) From a group of 7 items, a sequence of 3 can be picked distinctly in 210 ways. 210
=PERMUT(7.6;3) From a group of 7 items (floor value is taken), a sequence of 3 can be picked distinctly in 210 ways. 210
=PERMUT(11;-2) Cannot pick a negative number of items hence the function returns an error value. Err:502
=PERMUT(0;0) From a group of 0 items, a sequence of 0 can be picked in only 1 way. 1
=PERMUT(11;14) Cannot pick a sequence with more number of items than the total count hence the function returns an error value. Err:502

Related LibreOffice functions:

COMBIN

PERMUTATIONA

ODF standard:

Section 6.18.59, part 2

Equivalent Excel functions:

PERMUT