PERMUT

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 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

 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!


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