Excel functions / Statistics

PERCENTRANK.INC function

Where a value stands in a list, from 0 (the lowest) to 1 (the highest).

Syntax

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

Arguments

When to use it

PERCENTRANK.INC gives the share of the data below a value, from 0 for the lowest to 1 for the highest. A score with a percent rank of 0.75 did better than three quarters of the others.

Examples

  1. Where Ana's score stands

    ABCD
    1NameScore
    2Ana7250%
    3Ben48
    4Chloe90
    5Dev65
    6Eve81

    In D2: =PERCENTRANK.INC(B2:B6, B2) → 50%

    Try this example

  2. The top score

    ABCD
    1NameScore
    2Ana72100%
    3Ben48
    4Chloe90
    5Dev65
    6Eve81

    In D2: =PERCENTRANK.INC(B2:B6, MAX(B2:B6)) → 100%

    Try this example

Common mistakes

PERCENTRANK.INC 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

Also written as PERCENTRANK.

Try PERCENTRANK.INC in the playground

Related functions