Thursday, December 19, 2019

Purmut (Multiplies its arguments)












What Does It Do?
This function calculates the maximum number of permutations given a fixed number of items.
The internal order is significant, so AB and BA will be considered as two possible permutations.
It could be used to calculate the possible number of 4 digit passwords from the digits 0 to 9.
Syntax
=PERMUT(PoolToPickFrom,ItemsInAGroup)
Formatting
No special formatting is needed.
Example
The following table was used to calculate the total number of 8 letter passwords which can be created by using all 26 letters of the alphabet.
















In the case of a two letter password made from the letter A, B, C and D, the following twelve permutations would be possible.

No comments:

Post a Comment