Excel functions / Math
PERMUTATIONA function
The number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
Syntax
=PERMUTATIONA(number, number_chosen)
Arguments
number: How many different items there are.number_chosen: How many places there are to fill.
When to use it
PERMUTATIONA counts ordered arrangements when items may repeat: number to the power of how many are chosen. A 4-digit PIN has PERMUTATIONA(10, 4) possibilities.
Examples
Four-digit PINs
A B C D 1 Digits Length 2 10 4 10000 In D2:
=PERMUTATIONA(A2, B2)→ 10000
Common mistakes
- No repeats. If each item can be used only once, PERMUT is the one.
PERMUTATIONA in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PERMUTATIONA
- Danish: PERMUTATIONA
- Dutch: PERMUTATIE.A
- Finnish: PERMUTAATIOA
- French: PERMUTATIONA
- German: VARIATIONEN2
- Hungarian: VARIÁCIÓK.ISM
- Italian: PERMUTAZIONE.VALORI
- Norwegian: PERMUTASJONA
- Polish: PERMUTACJE.A
- Portuguese (Brazil): PERMUTAS
- Portuguese (Portugal): PERMUTAR.R
- Russian: ПЕРЕСТА
- Spanish: PERMUTACIONES.A
- Swedish: PERMUTATIONA
- Turkish: PERMÜTASYONA
Try PERMUTATIONA in the playground