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
array: The numbers.x: The value to place.significance(optional): How many digits to give (default 3).
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
Where 72 stands among five scores
A B C 1 Score 2 72 50% 3 48 4 90 5 65 6 81 In C2:
=PERCENTRANK.EXC(A2:A6, A2)→ 50%
Common mistakes
- Argument order. The range comes first, then the value.
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.
- Czech: PERCENTRANK.EXC
- Danish: PROCENTPLADS.UDELAD
- Dutch: PROCENTRANG.EXC
- Finnish: PROSENTTIJÄRJESTYS.ULK
- French: RANG.POURCENTAGE.EXCLURE
- German: QUANTILSRANG.EXKL
- Hungarian: SZÁZALÉKRANG.KIZÁR
- Italian: ESC.PERCENT.RANGO
- Norwegian: PROSENTDEL.EKS
- Polish: PROC.POZ.PRZEDZ.OTW
- Portuguese (Brazil): ORDEM.PORCENTUAL.EXC
- Portuguese (Portugal): ORDEM.PERCENTUAL.EXC
- Russian: ПРОЦЕНТРАНГ.ИСКЛ
- Spanish: RANGO.PERCENTIL.EXC
- Swedish: PROCENTRANG.EXK
- Turkish: YÜZDERANK.HRC
Try PERCENTRANK.EXC in the playground
Related functions
- PERCENTRANK.INC: Where a value stands in a list, from 0 (the lowest) to 1 (the highest).
- PERCENTILE.EXC: The value below which a percentage of the data falls, excluding 0% and 100%.
- RANK: The position of a number in a list (1 = largest by default).