Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

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.


= PERMUTATIONA(number, number-chosen)


  • 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:


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.