# Documentation/Calc Functions/PERMUT

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.

## 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:

## ODF standard:

## Equivalent Excel functions:

PERMUT