PERMUT function
Number
The number of objects.
ChosenNumber
The number of objects in each permutation.
Returns
The number of ordered permutations for a given number of objects.
Returns the number of permutations for a given number of objects, where an object can only be chosen once. (A permutation differs from a combination in that a permutation is ordered.)
For instance, consider a set of three objects, A, B and C. To choose two of these, only the following permutations are possible: AB, AC, BA, BC, CA and CB, for a total of six permutations. Indeed, PERMUT(3, 2)PERMUT(3; 2) returns 6.
Repetitions, like AA, BB and CC in the example above, are not allowed. To allow repetitions, use PERMUTATIONA instead.
Examples
Returns 6. If there are three objects, A, B and C, and two should be chosen, only the following six permutations are possible when objects cannot be repeated: AB, AC, BA, BC, CA and CB.
Returns 9. If there are three objects, A, B and C, and two should be chosen, only the following nine permutations are possible when objects can be repeated: AA, AB, AC, BB, BA, BC, CC, CA and CB. PERMUTATIONA differs from PERMUT in that objects can be repeated.