PERMUT Function
Calculates the number of permutations of a specified number of objects from a given set of objects
Calculates the number of permutations of a specified number of objects from a given set of objects
The PERMUT Function is categorized under FINANCIAL functions. The function will calculate the number of permutations of a specified number of objects from a given set of objects.
In financial analysis, PERMUT can be useful in calculating different possible permutations. So, it will help in rationally evaluating situations and making the correct choices on behalf of shareholders or clients.
=PERMUT(number, number_chosen)
The PERMUT function uses the following arguments:
As a worksheet function, the PERMUT function can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:
Let’s calculate the number of permutations of six objects selected from differently sized sets:
Number | Chosen | Result | Notes |
---|---|---|---|
5 | 1 | 5 | 5 possible permutations in group 1 |
5 | 2 | 20 | 20 possible permutations in group 1 |
5 | 3 | 60 | 60 possible permutations in group 1 |
5 | 4 | 120 | 120 possible permutations in group 1 |
5 | 5 | 120 | 120 possible permutations in group 1 |
We used the formula below:
We got the results below:
The number of permutations for a given number of objects is the number of combinations in each possible order.
Note that permutations differ from combinations in that, for a permutation, the order of the objects matters, but in a combination, the order does not matter.
The number of possible permutations is given by the formula:
Where:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:
To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.
Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!