PERMUT |
| PERMUT(number, number_chosen) |
Returns the number of permutations for a subset of objects or events (without repetition). |
| number | The total number of "unique" items. |
| number_chosen | The 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 |
|
| 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