PERMUT

PERMUT(number, number_chosen)

Returns the number of permutations for a subset of objects or events (without repetition).

numberThe total number of "unique" items.
number_chosenThe number of items in each permutation.

REMARKS
* A permutation is the number of possible arrangements of a set of objects when the order matters.
* If any of the arguments are not numeric, then #VALUE! is returned.
* If "number" is not an integer, it is truncated.
* If "number" <= 0, then #NUM! is returned.
* If "number_chosen" is not an integer, it is truncated.
* If "number_chosen" < 0, then #NUM! is returned.
* If "number" < "number_chosen", then #NUM! is returned.
* You can use the COMBIN function to return the number of combinations for a given number of items (without repetition).
* You can use the COMBINA function to return the number of combinations for a given number of items (with repetition).
* You can use the MULTINOMIAL function to return the number of permutations for a given number of items (with duplicates).
* You can use the PERMUTATIONA function to return the number of permutations (with repetition).
* For the Microsoft documentation refer to support.microsoft.com

 A
1=PERMUT(4, 4) = 24
2=FACT(4) = 24
3=PERMUT(8, 3) = 336
4=PERMUT(100, 1) = 100
5=PERMUT(100, 1.9) = 100
6=PERMUT(100, 2) = 9900
7=PERMUT(100, 3) = 970200
8=PERMUT(26, 8) = 62990928000
9=PERMUT(100, "text") = #VALUE!
10=PERMUT("text", 2) = #VALUE!

1 - How many different ways can the letters A, B, C, D be arranged.
2 - Same as Example 1 using the factorial function.
3 - How many ways can you arrange 3 numbers from the set {1,2,3,4,5,6,7,8}
4 - What are the odds of selecting a winning lottery number, which is 3 numbers, between 0 and 99, inclusive.
10 - How many different 8 letter passwords can be created by using all 26 letters of the alphabet.

© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top