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

Want to practice PERMUT 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

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

=PERMUT(number, number_chosen) Explain

Arguments

ArgumentRequired?What it does
numberYesThe number of items to choose from.
number_chosenYesHow many are chosen (in order).

Examples

Example 1 — Gold, silver and bronze

10 reps compete for 1st, 2nd and 3rd place.

B4fx=PERMUT(B2,B3)
AB
1MeasureValue
2Reps10
3Places3
4Podiums (order matters)720
5Groups of 3 (any order)120
=PERMUT(B2,B3) Explain

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:

=PERMUT(8,8) Explain

Returns 40,320 (8!).

Common mistakes

  • #NUM! number is less than number_chosen, or either 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.