PERMUTATIONA

The Excel PERMUTATIONA function returns the number of permutations (combinations where order is significant) for a given number of items. The PERMUTATIONA function allows repetitions. To calculate the number of permutations without repetitions, use the PERMUT function. A permutation is a combination where order matters. In other words, a permutation is an ordered combination. There are two types of permutations: The PERMUTATIONA function calculates permutations where repetitions are allowed. To calculate permutations where repetitions are not allowed, use the PERMUT function. A good real-world example is a numeric code: a 3-digit code using the digits 0-9 allows values like 123, 321, and 111. Order matters and digits can repeat, so this is a permutation with repetition. For a full explanat