This function returns the number of possible permutations for a specified number of items.
Syntax
PERMUT(k,n)
Arguments
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 |
Remarks
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.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
PERMUT(B3,5)
PERMUT(C4,B2)
PERMUT(R1C2,2)
PERMUT(8,2) gives the result 56
PERMUT(100,3) gives the result 970200
See Also