Excel functions / Math

PERMUTATIONA function

The number of ordered arrangements when the same item may be used more than once: number to the power of number_chosen.

Syntax

=PERMUTATIONA(number, number_chosen)

Arguments

When to use it

PERMUTATIONA counts ordered arrangements when items may repeat: number to the power of how many are chosen. A 4-digit PIN has PERMUTATIONA(10, 4) possibilities.

Examples

  1. Four-digit PINs

    ABCD
    1DigitsLength
    210410000

    In D2: =PERMUTATIONA(A2, B2) → 10000

    Try this example

Common mistakes

PERMUTATIONA 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 PERMUTATIONA in the playground

Related functions