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

ArgumentRequired?What it does
numberYesThe number of items to choose from.
number_chosenYesHow 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)
AB
1MeasureValue
2Digits10
33-digit codes1000
44-digit codes10000
54 different digits5040
=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

Kyle Stott

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.