How to Use Excel PERMUT Function in Office 365? – [with Examples]
Tags: excelfunctions, excelpermutfunctioni
Published: 2020-09-15 06:35:28

---
title: How to Use Excel PERMUT Function in Office 365? – [with Examples]
published: true
date: 2020-09-14 12:16:33 UTC
tags: ExcelFunctions,ExcelPERMUTFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-permut-function-in-office-365-with-examples/
---

## PERMUT Function:

![PERMUT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/PERMUT-Function.png)<figcaption id="caption-attachment-13872">PERMUT Function</figcaption>

In this guide, you will understand the usage of **Excel PERMUT Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **PERMUT Function – Description:**

- This function **returns the number of permutations from the given number of items**.
- **PERMUT Function** is not like [**COMBIN Function**](https://geekexcel.com/how-to-use-excel-combin-function-in-office-365-with-examples/). In the COMBIN Function, the internal order is significant but in Permutations, the internal order is not significant.
- You can manually calculate permutations by using the below formula.

![Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Formula-3.png)<figcaption id="caption-attachment-13867">Formula</figcaption>

## Syntax:

**=PERMUT(number, number\_chosen)**

### Arguments Explanation:

**number – ** It represents the total number of items.

**number\_chosen – ** It is the number of items in each permutation.

### Note:

- If either of the argument is non-numeric and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If the input number is less than the number\_chosen, it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to quickly understand the usage of **PERMUT** Function.

### Example 1:

- In the below image, you can see the inputs in **Column A, B** , and the result is listed in **Column D**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-47.png)<figcaption id="caption-attachment-13868">Example 1</figcaption>

### Example 2:

- If either of the argument is non-numeric and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- If the input number is less than the number\_chosen, it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-42.png)<figcaption id="caption-attachment-13869">Example 2</figcaption>

## Wrap-Up:

In this article, you can understand the usage of **Excel PERMUT Function in Office 365** with its syntax, explanation, and examples. Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use Excel SMALL Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)
- [How to Use “Excel COUNT Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)