PERMUTATIONA 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 objects can be repeated. (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: AA, AB, AC, BB, BA, BC, CC, CA and CB, for a total of nine permutations. Indeed, PERMUTATIONA(3, 2)PERMUTATIONA(3; 2) returns 9.
Repetitions, like AA, BB and CC in the example above, are allowed. To disallow repetitions, use PERMUT instead.
Examples
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.