Excel functions / Math
PERMUT function
How many ways to pick a number of items from a group, when the order matters.
Syntax
=PERMUT(number, number_chosen)
Arguments
number: How many items there are.number_chosen: How many are picked.
When to use it
PERMUT counts the ways to choose and arrange a number of items from a group when the order matters: first, second and third place, or the digits of a code with no repeats.
Examples
Gold, silver and bronze among 10 runners
A B C D 1 Runners Places 2 10 3 720 In D2:
=PERMUT(A2, B2)→ 720Ordered against unordered
A B C D 1 Runners Places 2 10 3 6 In D2:
=PERMUT(A2, B2)/COMBIN(A2, B2)→ 6Each group of three can be ordered 6 ways.
Common mistakes
- Repeats allowed. PERMUT assumes each item is used once. A PIN whose digits may repeat is PERMUTATIONA, or simply 10^4.
PERMUT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: PERMUTACE
- Danish: PERMUT
- Dutch: PERMUTATIES
- Finnish: PERMUTAATIO
- French: PERMUTATION
- German: VARIATIONEN
- Hungarian: VARIÁCIÓK
- Italian: PERMUTAZIONE
- Norwegian: PERMUTER
- Polish: PERMUTACJE
- Portuguese (Brazil): PERMUT
- Portuguese (Portugal): PERMUTAR
- Russian: ПЕРЕСТ
- Spanish: PERMUTACIONES
- Swedish: PERMUT
- Turkish: PERMÜTASYON
Related functions
- COMBIN: How many ways to choose a number of items from a group, when the order does not matter.
- PERMUTATIONA: The number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.
- FACT: Factorial: 1 × 2 × … × n.