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

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

  1. Gold, silver and bronze among 10 runners

    ABCD
    1RunnersPlaces
    2103720

    In D2: =PERMUT(A2, B2) → 720

    Try this example

  2. Ordered against unordered

    ABCD
    1RunnersPlaces
    21036

    In D2: =PERMUT(A2, B2)/COMBIN(A2, B2) → 6

    Each group of three can be ordered 6 ways.

    Try this example

Common mistakes

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.

Translate a whole formula

Try PERMUT in the playground

Related functions