Excel functions / Statistics

PERCENTRANK.EXC function

Where a value stands in a list, between 0 and 1 without ever reaching either.

Syntax

=PERCENTRANK.EXC(array, x, [significance])

Arguments

When to use it

PERCENTRANK.EXC gives where a value stands in a list, as a share strictly between 0 and 1. PERCENTRANK.INC gives 0 to the lowest value and 1 to the highest.

Examples

  1. Where 72 stands among five scores

    ABC
    1Score
    27250%
    348
    490
    565
    681

    In C2: =PERCENTRANK.EXC(A2:A6, A2) → 50%

    Try this example

Common mistakes

PERCENTRANK.EXC 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 PERCENTRANK.EXC in the playground

Related functions