PERMUT function in Excel

PERMUT function in Excel


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

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:

Ham permut in excel 2

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:

Ham permut in excel 3

Step 1: Enter the syntax of the function calculated in the cell C3 as follows:

Ham permut in excel 4

Step 2: You press the key Enter To get the result of the function:

ham permut in excel 5

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

Ham permut in excel 6

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

Ham permut in excel 7

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

Ham permut in excel 8

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

Ham permut in excel 9

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.

.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *