Returns the number of possible permutations for a specified number of objects
Over 1.8 million professionals use CFI to learn accounting, financial analysis, modeling and more. Start with a free account to explore 20+ always-free courses and hundreds of finance templates and cheat sheets.
The PERMUTATIONA Function is an Excel Statistical function. It returns the number of permutations that are possible for a specified number of objects in a given set. Introduced in MS Excel 2013, it’s important to note the function includes repetitions in the number it returns.
The PERMUTATIONA function includes the following arguments:
Number (required argument) – This is an integer that describes the total number of objects.
Number_chosen (required argument) – An integer that describes the number of objects in each permutation.
How to use the PERMUTATIONA Function in Excel?
To understand the uses of the function, let’s consider a few examples:
We wish to calculate the number of permutations (with repetitions) of six objects, selected from different sized sets.
As you can see above, the function truncates the decimal value to integers, so we got the same result for:
PERMUTATIONA(50,3) and PERMUTATIONA(50,3.5), that is 125,000 possible permutations.
Combinations and permutations are different and, hence, they use different formulas. In a combination, the objects can be in any order, whereas in a permutation, the order is important.
Difference between PERMUT and PERMUTATIONA Functions
Both the PERMUT and PERMUTATIONA functions calculate the number of permutations of a selection of objects from a set.
However, there is a difference between the two functions. PERMUT does not count repetitions whereas PERMUTATIONA counts repetitions.
For example, in a set of three objects – a, b, and c – how many permutations are possible?
Under the PERMUT function, the result will give six possible permutations:
Whereas, the PERMUTATIONA function will return the following results:
A few notes about PERMUTATIONA Function
#VALUE! error – Occurs when “number” or “number_chosen” is not numeric.
#NUM! error – Occurs when:
The supplied number argument less than 0; or
The supplied number_chosen argument is less than 0; or
The supplied number argument is less than the number_chosen argument.
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Take your learning and productivity to the next level with our Premium Templates.
Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.
Already have a Self-Study or Full-Immersion membership? Log in
Access Exclusive Templates
Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.