# Documentation/Calc Functions/PERMUTATIONA

Jump to navigation
Jump to search

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

## 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:
**Count1**^{Count2} - 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:

## ODF standard:

## Equivalent Excel functions:

PERMUTATIONA