Learn How to Use Microsoft Excel PERMUTATIONA Function

Microsoft Excel PERMUTATIONA Function

The main purpose of the Microsoft Excel PERMUTATIONA function is to get the number of permutations with repetitions. That implies, with the help of PERMUTATIONA function you can able to return the number of permutations, which are the combinations where the order is significant for a given number of items. It should be noted that PERMUTATIONA function allows repetitions. In case you want to allow permutations without repetitions, use the PERMUT function. So, with the help of PERMUTATIONA function, you can able to get the number of permutations with repetitions.

Return Value of PERMUTATIONA Function

The return value will be the number of permutations with repetitions.

Syntax of PERMUTATIONA Function

=PERMUTATIONA(number, number-chosen)

Where the arguments:

• number: This is the total number of items.
• number-chosen: This is the number of items in each combination.

How to Use Microsoft Excel PERMUTATIONA Function?

So we know that Microsoft Excel PERMUTATIONA function you can able to get the number of permutations with repetitions. That implies, with the help of PERMUTATIONA function you can able to return the number of permutations, which are the combinations where an order is significant for a given number of items. It should be noted that PERMUTATIONA function allows repetitions. In case you want to allow permutations without repetitions, use the PERMUT function. So, with the help of PERMUTATIONA function, you can able to get the number of permutations with repetitions.

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel