PERMUT |
PERMUT(number, number_chosen) |
Returns the number of permutations for a subset of objects or events. |
number | The total number of items. |
number_chosen | The number of items in each permutation. |
REMARKS |
* 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. * Returns the number of permutations for a given number of objects that can be selected from number objects. 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. * Suppose you want to calculate the odds of selecting a winning lottery number. Each lottery number contains three numbers, each of which can be between 0 (zero) and 99, inclusive. The following function calculates the number of possible permutations: * You can use the COMBIN function to return the number of combinations for a given number of items. * You can use the PERMUTATIONA function to return the number of permutations (with repetition). * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top