PERMUTATIONA function in Excel calculates the number of permutations of a specified number of objects with repetitions.For example, in a set of 3 objects – a, b, c, how many permutations with repetition of 2 objects are there?
The PERMUTATIONA Function returns the result as 9 (elements are ab, ac, ba, bc, ca, cb, aa, bb, cc).
Syntax of PERMUTATIONA Function in Excel:
number -The total number of objects available.
number_chosen – Number of objects selected from the set.
Example of PERMUTATIONA Function in Excel
Formula:
In the first example PERMUTATIONA(3,2) with repetition is calculated whose value is 9, Similarly all the permutation is computed based on the inputs, number (n) and number chosen (k) so the result will be
Result
Note:
#NUM! – Error occurs if
- The supplied number is < 0;
- The supplied number_chosen is < 0;
- The supplied number is < the number_chosen argument.