Excel - Microsoft Excel PERMUT Function

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 : 

PERMUT( number, number_chosen ) 

Where the function arguments are: 

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. 

Permut Function Errors

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

Common Errors