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.
Download Practice Workbook
You can download our practice workbook from here for free!
Introduction to Excel PERMUT Function
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.
The syntax of the PERMUT function is as follows:
|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.
- First and foremost, click on the first cell where you want to put your result (cell D5 here).
- Afterward, insert the formula below.
- 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.
- First, click on cell D5 to get your result there.
- Following, insert the formula below in the formula bar and press the Enter key.
- 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.
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!