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

NumberNumber_ChoosenResult(Permutationa)
3327
224
44256

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.