The Excel PERMUT function calculates the number of permutations of a specified number of objects from a set of objects.
Syntax: PERMUT( number, number_chosen )
Where the function arguments are:
|number||–||The total number of objects available|
|number_chosen||–||The number of objects in each permutation (i.e. the number selected from the total set)|
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:
|#NUM!||–||Occurs if either the supplied number ≤ 0 or the supplied number_chosen < 0 the supplied number < number_chosen|
|#VALUE!||–||Occurs if either the number or the number_chosen argument is non-numeric|