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:


Excel Function Syntax

PERMUTATIONA(number, number-chosen)


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


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.