Statistical - PERMUTATIONA Function

Description

The PERMUTATIONA function returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects.

PERMUTATIONA uses the following equation −

$$PERMUTATIONA=Total^{Chosen}$$

Syntax

PERMUTATIONA (number, number-chosen)

Arguments

Argument	Description	Required/ Optional
Number	An integer that describes the total number of objects.	Required
Number_chosen	An integer that describes the number of objects in each permutation.	Required

Notes

Both arguments are truncated to integers.
If one or both of the supplied arguments are non-numeric, PERMUTATIONA returns the #VALUE! error value.
If number < 0, PERMUTATIONA returns the #NUM! error value.
If number_chosen < 0, PERMUTATIONA returns the #NUM! error value.
If number < number_chosen, PERMUTATIONA returns the #NUM! error value.

Applicability

Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm