PERMUT Function in Excel – Calculate Permutation in Excel

PERMUT function in Excel calculates the number of permutations of a specified number of objects. For example, in a set of 3 objects – abc, how many permutations of 2 objects are there?

The PERMUT Function returns the result as 6 (elements are abacbabccacb). And the general formula for permutation is

PERMUT FUNCTION IN EXCEL1

Syntax of PERMUT Function in Excel:

PERMUT( number, number_chosen )

number -The total number of objects available.

number_chosen – Number of objects selected from the set.

 

Example of PERMUT Function in Excel

Formula

PERMUT FUNCTION IN EXCEL 2

 

  • In the first example P(3,2) is calculated which is – 3!/(3-2)! And its value being 6

Similarly all the permutation is computed based on the inputs,  number (n) and number chosen (k) so the result will be

Result

PERMUT FUNCTION IN EXCEL 3

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 PERMUT Function in Excel                                                                                                                next PERMUT Function in Excel