Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelPERMUT Function in Excel

# PERMUT Function in Excel

In this article, you will learn about the PERMUT function, the formula syntax and usage of the function in Microsoft Excel.

## PERMUT Function in Excel

The PERMUT function in Excel returns the number of permutationsÂ for a given number of items/objects. Generally, permutation is any set or subset of objects or events where the internal order or the number of possibilities is significant.

The PERMUT functionÂ does notÂ allow repetitions.

It is commonly used for lottery-style probability calculations.

#### Syntax

= PERMUT(number, number_chosen)

Arguments:

• NumberÂ Â â€“ An integer that describes the number of objects.
• Number_chosenÂ â€“ An integer that describes the number of objects in each permutation.

## Usage Notes and Possible Errors

• Both arguments are truncated to integers.
• When any one of the argument is nonnumeric, the PERMUT function returns the #VALUE! error value.
• When the argument, number â‰¤ 0 or if number_chosen < 0, the PERMUT function returns the #NUM! error value.
• The PERMUT function returns the #NUM! error value, when the Â number is greater than number_chosen.
• The equation or the mathematical formula for the number of permutations is:Â Â Â Â Â Â Â Â Â Â Â

## How to use the PERMUT function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

Enter the data in the respective columns and enter the PERMUT function formula.

Formula: Â = PERMUT(A2,B2)

Here, A2 refers to the cell name or the cell address. Column A denotes the number and Column B denotes the number of objects in each permutation.

You will get the result in the Result column.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021