PERMUT function

PERMUT(number, chosenNumber) PERMUT(number; chosenNumber)

number — Number or { Number }

The number of objects.

chosenNumber — Number or { Number }

The number of objects in each permutation.

Returns — Number or { Number }

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

PERMUT(3, 2)PERMUT(3; 2)

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.