HomeApplicationOffice information

PERMUT function - The function returns the number of permutations of a given number of objects in Excel

PERMUT function: The function returns the number of permutations of a given object. Permutations are subsets of values ​​where the position and number of elements in permutations are different. Syntax: PERMUT (number, number_chosen)

The following article introduces you to the PERMUT function - one of the functions in the statistical function group is very popular in Excel.

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 1PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 1

Description: The function returns the number of permutations of a given object. Permutations are subsets of values ​​where the position and number of elements in permutations are different.

Syntax: PERMUT (number, number_chosen)

Inside:

- number: Integer specifies the number of objects, is the required parameter .

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

Attention:

- If number, number_chosen are not whole numbers -> they are truncated to whole numbers.

- If number, number_chosen are not numbers -> the function returns the #VALUE! Error value

- If number -> the function returns the #NUM! Error value

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

- The equation for numbers and permutations is:

[{P_ {k, n}} = frac {{n!}} {{Left ({n - k} right)!}}]

For example:

Find the number of permutations consisting of 4 elements from 93 elements described in the following data table:

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 2PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 2

- In the cell to calculate enter the formula : = PERMUT (E6, E7)

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 3PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 3

- Press Enter -> The number of permutations includes 4 elements:

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 4PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 4

- Where number (number of objects) (number of objects in a permutation) -> function returns the #NUM! Error value

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 5PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 5

- Where number ≤ 0 or number_chosen <0 -> the function returns the #NUM! Error value

PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 6PERMUT function - The function returns the number of permutations of a given number of objects in Excel Picture 6

Above are instructions and some specific examples when using PERMUT function in Excel.

Good luck!

3.5 ★ | 2 Vote

You should read it

May be interested

Office information