PERCENTRANK function
The PERCENTRANK function returns the rank of a value in a dataset as a percentage of the dataset -- essentially, the relative standing of a value within the whole dataset. For example, you could use PERCENTRANK to determine the standing of an individual's test score among the field of all scores for the same test.
Syntax
PERCENTRANK(array, x, [significance])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| array | Yes | Required. The range of data (or pre-defined array) of numeric values within which percent rank is determined.A1:A4 |
| x | Yes | Required. The value for which you want to know the rank within the array.1.5 |
| significance | No | Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK uses three digits (0.xxx).3 |
Try PERCENTRANK
Read the legacy PERCENTRANK function name
=PERCENTRANK(A2:A5,20,6)PERCENTRANK is the compatibility name corresponding to PERCENTRANK.INC. Inclusive endpoints use ranks 0 through 1, so the second of four sorted values has rank 1/3. The third argument retains six significant digits in the returned rank. Use the modern name when creating a new formula; the old spelling is useful when reading existing workbooks.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
PERCENTRANK · top-level call
=PERCENTRANK(A2:A5,20,6)1 / 3 · array
Required. The range of data (or pre-defined array) of numeric values within which percent rank is determined.
PERCENTRANK reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.