PERMUTATIONA Function
Returns the number of ordered arrangements when items can repeat.
Category
Statistical
Available in
Excel 2013+, Microsoft 365
Returns
A whole number
Want to practice PERMUTATIONA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
PERMUTATIONA counts ordered selections where each position can use any item again: number ^ number_chosen. Think codes, PINs and passwords.
Syntax
=PERMUTATIONA(number, number_chosen) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number of items to choose from. |
| number_chosen | Yes | How many positions to fill. |
Examples
Example 1 — How many door codes?
Codes use the digits 0–9 and may repeat a digit.
B3fx=PERMUTATIONA(B2,3)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Digits | 10 |
| 3 | 3-digit codes | 1000 |
| 4 | 4-digit codes | 10000 |
| 5 | 4 different digits | 5040 |
=PERMUTATIONA(B2,3) Explain
Allowing repeats gives 10,000 four-digit codes versus 5,040 with all-different digits.
Common mistakes
- #NUM! Either argument is negative.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.