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.|
|* If you want to return the number of permutations (with repetition) you can use the PERMUTATIONA function.|
* 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:
* This function is closely related to the COMBIN.
* For the Microsoft documentation refer to support.office.com
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top