PERMUT function in Excel calculates the number of permutations of a specified number of objects. For example, in a set of 3 objects – a, b, c, how many permutations of 2 objects are there?
The PERMUT Function returns the result as 6 (elements are ab, ac, ba, bc, ca, cb). And the general formula for permutation is
Syntax of PERMUT Function in Excel:
PERMUT( number, number_chosen )
number -The total number of objects available.
number_chosen – Number of objects selected from the set.
Example of PERMUT Function in Excel
Formula
- In the first example P(3,2) is calculated which is – 3!/(3-2)! And its value being 6
Similarly all the permutation is computed based on the inputs, number (n) and number chosen (k) so the result will be
Result
Note:
#NUM! – Error occurs if
- The supplied number is < 0;
- The supplied number_chosen is < 0;
- The supplied number is < the number_chosen argument.