PERMUTATIONA function

This article describes the formula syntax and usage of the PERMUTATIONA function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

Syntax

PERMUTATIONA(number, number-chosen)

The PERMUTATIONA function syntax has the following arguments:

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

PERMUTATIONA uses the following equation:

PERMUTATIONA equation

Remarks

  • Both arguments are truncated to integers.
  • If numeric arguments are values that are not valid, for example, when the total number is zero (0) and the chosen number is larger than zero (0), PERMUTATIONA returns the #NUM! error value.
  • If numeric arguments use data types that are nonnumeric, PERMUTATIONA returns the #VALUE! error value.

Example

The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.

To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel Online