PERMUT Function - Returns the number of permutations of a given set of objects in Excel

This article introduces you to the PERMUT function - one of the functions in the statistical group widely used in Excel.

Description: Returns the number of permutations of a given set of objects. Permutations are subsets of the set of values where the positions and the number of elements in the permutations are different.

Syntax: PERMUT(number, number_chosen)

In this context:

- number: An integer that determines the number of objects, which is a mandatory parameter.

- number_chosen: An integer that determines the number of objects in a permutation, which is a mandatory parameter.

Note:

- If number and number_chosen are not integers -> they are rounded to the nearest integer.

- If number and number_chosen are not numeric -> the function returns an error value #VALUE!

- If number is less than number_chosen -> the function returns an error value #NUM!

- If number is less than or equal to 0 or number_chosen is less than 0 -> the function returns an error value #NUM!

- The formula for permutations is:

Pk,n=n!(n−k)!$P_{k,n}=\frac{n!}{\left(n-k\right)!}$

Example:

Find the permutations of 4 elements from 93 elements described in the data table below:

- Enter the formula: =PERMUT(E6,E7)

- Press Enter -> the permutations of 4 elements is:

- If number (number of objects)< number_chosen (number of objects in each permutation) -> the function returns an error value #NUM!

- If number ≤ 0 or number_chosen < 0 -> the function returns an error value #NUM!

Here is a guide and some specific examples when using the PERMUT function in Excel.

Wishing you all success!