PERMUT Function
Returns the number of ordered arrangements of items chosen from a group, without repeats.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A whole number
Overview
PERMUT counts how many ways you can pick number_chosen items from number items when the order matters and an item can't be picked twice: n! ÷ (n − k)!.
If order doesn't matter, use COMBIN; if items can repeat, use PERMUTATIONA.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The number of items to choose from. |
| number_chosen | Yes | How many are chosen (in order). |
Examples
Example 1 — Gold, silver and bronze
10 reps compete for 1st, 2nd and 3rd place.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Reps | 10 |
| 3 | Places | 3 |
| 4 | Podiums (order matters) | 720 |
| 5 | Groups of 3 (any order) | 120 |
720 possible podiums — 6 times the 120 groups, because each group of 3 can be ordered 6 ways.
Example 2 — Ordering everyone
8 presentations in a running order:
Returns 40,320 (8!).
Common mistakes
- #NUM! number is less than number_chosen, or either is negative.
Notes
- Decimals are truncated to whole numbers.
- Related functions: PERMUTATIONA, COMBIN, FACT.

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.