The Excel PERMUT Function

Permutations

The number of permutations for a given number of objects is the number of combinations in each possible order.

The number of possible permutations of is given by the formula:

where k is the number of objects chosen and n is the number of possible objects.

Further information can be found on the Wikipedia Permutation page

Basic Description

The Excel PERMUT function calculates the number of permutations of a specified number of objects from a set of objects.

The format of the function is :

Where the function arguments are:

Formulas:

Results:

Permut Function Examples

The spreadsheet on the right shows several examples of the Excel Permut function used to show the number of permutations of six objects, selected from different sized object sets.

The format of the functions are shown in the top spreadsheet and the resulting values are shown in the spreadsheet below.

Further examples of the Excel Permut function can be found on the Microsoft Office website.

Trouble Shooting

If you get an error from the Excel Permut Function, this is likely to be one of the following: