# PERMUTATIONA Function in Excel

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

## PERMUTATIONA Function in Excel

The PERMUTATIONA function in Excel returns the number of permutations with repartitions for a given number of items.

#### Syntax

= PERMUTATIONA(number, number-chosen)

Arguments:

• Number   – An integer that describes the total number of objects.
• Number_chosen   – An integer that describes the number of objects in each permutation.

Equation for PERMUTATIONA:

PERMUTATIONA=TotalChosen

## Usage Notes and Possible Errors

• The arguments are truncated to integers.
• When the numeric arguments are values that are not valid, the PERMUTATIONA function returns the #NUM! error value.
• In case of the numeric arguments using data types that are nonnumeric, the PERMUTATIONA function returns the #VALUE! Error value.

## How to use the PERMUTATIONA 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 PERMUTATIONA function formula.

Formula: = PERMUTATIONA (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.