PERMUT
Definition of PERMUT
Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
Sample Usage
PERMUT(4,2)
PERMUT(A2,B2)
Syntax
PERMUT(n, k)
n
- The size of the pool of objects to choose from.k
- The number of objects to choose.
Notes
PERMUT
is the standard combinatorics function typically notated nPk. This is similar toCOMBIN
except in permutations, the order of selection is considered rather than simply the resultant selected subset.
See Also
MULTINOMIAL
: Returns the factorial of the sum of values divided by the product of the values' factorials.
FACTDOUBLE
: Returns the "double factorial" of a number.
FACT
: Returns the factorial of a number.
COMBIN
: Returns the number of ways to choose some number of objects from a pool of a given size of objects.
In order to use the PERMUT formula, start with your edited Excellentable
Then type in the PERMUT Formula in area you would like to display the outcome:
Type in the complete PERMUT formula for a cell as shown below:
Excellentable will generate the outcome when hitting enter.
A
|
B
|
C
|
D
|
|
---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|