Author: Oscar Cronquist Article last updated on April 20, 2018

The PERMUTATIONA function returns the number of permutations for a specific number of elements that can be selected from a larger group of elements.

Repetition is allowed.

Formula in cell D3:

=PERMUTATIONA(B3,C3)

Excel Function Syntax

PERMUTATIONA(number, number-chosen)

Arguments

number The total number of elements.
number-chosen A specific number of elements.

Comments

The picture above shows permutations with repetition allowed, 2 out of 3 numbers. The numbers are 1,2 and 3 and there are 9 permutations.