PERMUT
Name
Permutation
Description
Returns the number of possible permutations for a specified number of items.
Syntax
PERMUT(value1, value2)
Remarks
Specify the number of items using the value1 argument. Specify the number of items in each possible permutation using the value2 argument. Both arguments must be positive integers, and the value1 argument must be greater than 0.
A permutation is any set or subset of items where internal order is significant. Contrast with combinations (the COMBIN function).
The number of permutations is calculated as follows:
See also COMBIN.
Data Type
Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
PERMUT(R1C2,2)
PERMUT(B3,5)
PERMUT(C4,B2)
PERMUT(8,2)=56
PERMUT(100,3)=970200