Returns the number of permutations for the specified number of objects that can be selected from another specified number of objects.
Syntax
 Copy Code
|
|---|
PERMUT( Integer n, Integer k ) → Integer |
Parameters
- n
- Required. The total number of objects. Must be a positive number.
- k
- Required. The number of objects in each permutation. Must be a positive number.
Remarks
A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. The number of permutations is n!/(n-k)! where ! denotes factorial.
If n is less than k, or either n or k are negative or zero, the function returns the #NUM! error value.
Example
| Formula
Copy Code
|
|---|
=PERMUT(50,5) |
See Also
Function Reference
FACT Function
COMBIN Function