Formula Functions > Functions M to Q > PERMUT |
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
This function is available in product version 1.0 or later.
COMBIN | Math and Trigonometry Functions