This function returns the number of possible permutations for a specified number of items.
PERMUT(k,n)
This function has these arguments:
Argument | Description |
---|---|
k | Number of items; must be greater than 0; if not an integer, the number is truncated |
n | Number of items in each possible permutation; must be positive or 0; if not an integer, the number is truncated |
A permutation is any set or subset of items where internal order is significant. Contrast with combinations (the COMBIN function).
The equation for this function is:
where k and n are defined in the arguments.
Accepts numeric data for both arguments. Returns numeric data.
PERMUT(B3,5)
PERMUT(C4,B2)
PERMUT(R1C2,2)
PERMUT(8,2) gives the result 56
PERMUT(100,3) gives the result 970200