PERMUT(number, number_chosen)

Returns the number of permutations for a subset of objects or events.

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

Remarks

* 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

 A
1=PERMUT(100,1) = 100
2=PERMUT(100,1.9) = 100
3=PERMUT(100,2) = 9900
4=PERMUT(100,3) = 970200
5=PERMUT(100,"some text") = #VALUE!
6=PERMUT("some text",2) = #VALUE!


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