Learn How to Use Microsoft Excel PERMUT Function

Microsoft Excel PERMUT Function

The main purpose of the Microsoft Excel PERMUT function is to get the number of permutations without repetitions. That implies, with the help of PERMUT 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 PERMUT function does not allow repetitions. In case you want to allow permutations with repetitions, use the PERMUTATIONA function. So, with the help of PERMUT function, you can able to get the number of permutations without repetitions.

Return Value of PERMUT Function

The return value will be the number of permutations as an integer.

Syntax of PERMUT Function

=PERMUT(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 PERMUT Function?

So we know that Microsoft Excel PERMUT function you can able to get the number of permutations without repetitions. That implies, with the help of PERMUT 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 PERMUT function does not allow repetitions. In case you want to allow permutations with repetitions, use the PERMUTATIONA function. So, with the help of PERMUT function, you can able to get the number of permutations without 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