PERMUTATIONA Function in Excel

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 – abc, how many permutations with repetition of 2 objects are there?

The PERMUTATIONA Function returns the result as 9 (elements are abacbabccacb, aa, bb, cc).

Syntax of PERMUTATIONA Function in Excel:

PERMUTATIONA( number, number_chosen )

number -The total number of objects available.

number_chosen – Number of objects selected from the set.

 

Example of PERMUTATIONA Function in Excel

Formula:

PERMUTATIONA FUNCTION IN EXCEL 1

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

PERMUTATIONA FUNCTION IN EXCEL 2

Note:

 #NUM!  – Error occurs if

  • The supplied number is < 0;
  • The supplied number_chosen is < 0;
  • The supplied number is < the number_chosen argument.

previous-small PERMUTATIONA Function in Excel                                                                                                                next_small PERMUTATIONA Function in Excel