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

**â¦¿**** 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

**argumentâ€™s value.**

*number***â¦¿**** 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

**value is different in each row. Now, you need to**

*number of objects in each permutation***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
argument must be lesser than the*number_chosen*argument. Otherwise, it would return a*number***#NUM!**error. - If the
**number****#NUM!**error. - If the
argument is negative, the function would return a*number_chosen***#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!