**The PERMUT function in Excel helps you calculate to give the result that the number of permutations for a given number of objects can be selected from the number of objects. Please follow the article on how to use this function in the content written below.**

Jaw **PERMUT **Excel’s built-in function is classified as a Statistical function. It can be used as a worksheet (WS) in Excel. Is a worksheet function, function **PERMUT **may be entered as part of the formula in a cell of the worksheet.

How to use the PERMUT function in MS Excel

**PERMUT function in Excel**

**PERMUT function in Excel**

*1. The function syntax is PERMUT *

This function returns the number of permutations for a given number of objects. Permutations are subsets of values where the position and number of elements in permutations are different.

*PERMUT (number, number_chosen)*

**Inside:**

– **Number**: Integer specifies the number of objects, which is the required parameter.

– **Number_chosen**: Integer specifies the number of objects in a permutation, which is a required parameter.

*2. Some Notes when using PERMUT function *

– If **Number**, **Number_chosen **not integers -> they are truncated to whole numbers.

– If **Number**, **Number_chosen **not numeric -> function returns error value **#VALUE!**

– If **Number** less **Number_chosen **-> function returns error value **#NUM!**

– If **Number** ≤ 0 or **Number_chosen ** The function returns the error value **#NUM!**

– The equation for numbers and permutations is:

*3. Illustrative example*

Calculate the number of permutations for a given number of objects that can be selected from the number of objects with specific information such as the following worksheet image:

** Step 1: **Enter the syntax of the function calculated in the cell

**C3**as follows:

** Step 2: **You press the key

**Enter**To get the result of the function:

** Step 3: **Copy the calculation function to the box below to get the corresponding result:

In case **Number **less **Number_chosen **then the function is calculated **PERMUT **will produce an error **#NUM! **as the spreadsheet image below:

– If **Number** ≤ 0 or **Number_chosen ** The function returns the error value **#NUM!**

If **Number**, **Number_chosen **not numeric -> function returns error value **#VALUE!**

The article above has shown you how to use it **PERMUT function in Excel**. This function returns the number of permutations for a given number of objects in MS Excel. Hopefully this article will help you in your work as well as in your studies

https://thuthuat.taimienphi.vn/ham-permut-in-excel-44330n.aspx

In addition, you should learn and refer to the basic functions in Excel that Taimienphi.vn introduced, share to see and review formulas and how to use functions in Excel.

.