Excel like a finance pro.
← The libraryPractice · 2 questions →
Statistical function
PERMUTATIONA
Returns the number of permutations with repetitions allowed.
Rarely usedDifficulty 1350 · AdvancedUsage rank #329 of 520
When to use it
Permutations with repetition: n^k. Ordered sequences where any item can repeat, like PINs and passwords.
The shape of it
- Syntax
=PERMUTATIONA(number, number_chosen)
Worked examples
Small case
=PERMUTATIONA(3,2) → 9
Two-letter strings from three letters, repeats allowed.
PIN codes
=PERMUTATIONA(10,4) → 10000
Four-digit PINs.
Letter codes
=PERMUTATIONA(26,3) → 17576
Three-letter codes.
Worth knowing
- Same as POWER(n,k).
- PERMUT is the no-repeat version.
- Non-integers are truncated.
Where it goes wrong
- #NUM! for negative arguments.
- Overflows quickly for large k.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.