PERMUTATIONA function

Category: Statistical
Introduced: Excel 2013

Summary

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects

Syntax

PERMUTATIONA(number, number-chosen) The PERMUTATIONA function syntax has the following arguments:
• Number Required. An integer that describes the total number of objects.
• Number_chosen Required. An integer that describes the number of objects in each permutation.
PERMUTATIONA uses the following equation:

Example

=PERMUTATIONA(3,2)
=PERMUTATIONA(2,2)

Microsoft Support Page

https://support.microsoft.com/en-us/office/permutationa-function-6c7d7fdc-d657-44e6-aa19-2857b25cae4e

Back to Functions