MS Excel: Permut Function
In Excel, the Permut function returns the number of permutations for a specified number of items.
The syntax for the Permut function is:
Permut( number, chosen )
number is the number of items.
chosen is the number of items in each permutation.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Permut(A1, A2) would return 30240 =Permut(A1, A3) would return 720 =Permut(21, 5) would return 2441880