How to Use PERMUT Function in Excel (with an Alternative)

Get FREE Advanced Excel Exercises with Solutions!

Excel is extremely useful to perform extensive calculations and solve advanced mathematical problems. Now, in mathematics or real life, sometimes we need to calculate the number of choices possible for a specific number of objects from a total number of objects. In this regard, we can use the permutation method in mathematics. And, in Excel, we can achieve this result through the PERMUT function. In this article, I will show you how to use the PERMUT function in Excel.

Excel PERMUT Function: A Quick OverviewÂ  Â

You can have a quick overview of the Excel PERMUT function through the image below.

Introduction to Excel PERMUT Function

â¦¿ Summary:

The PERMUT function mainly returns the number of permutations for a chosen number of objects from a total number of objects without repetitions. Say, you have total of 10 objects and you want to calculate permutation for choosing 1 object from these 10 objects without repetitions. Here, you can apply this function to get the result.

â¦¿ Syntax:

The syntax of the PERMUT function is as follows:

`=PERMUT(number,number_chosen)`

â¦¿ Arguments:

Argument Required/Optional Value
number RequiredÂ  Total Number of Objects
number_chosen RequiredÂ  The Specific number of objects to choose from the total number of objects

â¦¿ Return Value:

Returns the permutation number for number_chosen argument value from the number argumentâ€™s value.

â¦¿ Available in:

Office 365 | Excel 2019 | Excel 2016 | Excel 2013 | Excel 2011 for Mac | Excel 2010 | Excel 2007 | Excel 2003 | Excel XP | Excel 2000.

Example to Use PERMUT Function in Excel

Say, you have a dataset with 10 rows where the total number of objects value is 10 in every row. But, the number of objects in each permutation value is different in each row. Now, you need to calculate the permutations at every row with respective values without repetitions. Follow the steps below to accomplish this result through the PERMUT function.

ðŸ“Œ Steps:

• First and foremost, click on the first cell where you want to put your result (cell D5 here).
• Afterward, insert the formula below.
`=PERMUT(B5,C5)`
• Following, hit the Enter key.

• As a result, you will get the permutation result for choosing 1 object from 10 objects without repetition.
• At this time, place your cursor in the bottom right position of cell D5.
• Following, a black fill handle will appear.
• Subsequently, drag the fill handle below to copy the same formula for all the cells below.

Thus, you will get all the permutation answers from your dataset using the PERMUT function. And, the result would look like this.

Read More: How to Generate or List All Possible Permutations in Excel

The PERMUTATIONA Function: Alternative to Excel PERMUT for Permutation with Repetition

Now, sometimes, it might occur that, you need permutation answers with repetition. Say, you have the same dataset as before. But, now, you need to calculate permutations for the chosen objects from the total objects with repetition. In this case, you can not use the PERMUT function. Rather, you will have to use the PERMUTATIONA function. Follow the steps below to achieve this.

ðŸ“Œ Steps:

• First, click on cell D5 to get your result there.
• Following, insert the formula below in the formula bar and press the Enter key.
`=PERMUTATIONA(B5,C5)`

• As a result, you will get your desired result for the first row.
• Subsequently, for all the other rows below, place your cursor in the bottom right position of the cell and drag your fill handle below upon its arrival.

Thus, you will get all the permutation values for given data and conditions with repetition. And, finally, the outcome should look like this.

Read More: How to Create Permutation Table in Excel (4 Easy Methods)

ðŸ’¬ Things to Remember

• If any of the arguments inserted is non-numeric, the function would return a #VALUE! error.
• If any of the arguments inserted is fractional or decimal, the function would truncate them into integer values.
• The number_chosen argument must be lesser than the number argument. Otherwise, it would return a #NUM! error.
• If the number argument is 0 or negative, the function would return a #NUM! error.
• If the number_chosen argument is negative, the function would return a #NUM! error.

Conclusion

So, in this article, I have shown you how to use the PERMUT function in Excel. Besides, you can download our free workbook to practice. I hope you find this article helpful and informative. However, if you have any further queries or recommendations, please feel free to comment here.

And, visit ExcelDemy to learn more things about Excel! Have a nice day! Thank you!

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF