PERCENTRANK

Excel Functions

Get percentile rank, inclusive

Syntax

EXCEL

=PERCENTRANK(array, x, [significance])

Arguments

Parameter	Description
`array`	Array of data values.
`x`	Value to rank.
`significance`	[optional] Number of significant digits in result. Defaults to 3.

Return Value

Calculated rank as a decimal value

Details

The PERCENTRANK function returns the relative standing of a value within a data set as a percentage. For example, a test score greater than 80% of all test scores is said to be at the 80th percentile. In this case, PERCENTRANK will assign a rank of .80 to the score. To use PERCENTRANK, provide an array of values (typically a range) and the value to rank, x. In the example shown, the formula in C5 is: where data is the named range B5:B12. As the formula is copied down, it returns the rank of each value in column B as a decimal value. To display the results in column C as a percentage, apply the percentage number format. The table in the range F4:G15 is for reference only. It uses the PERCENTILE function in column G to calculate a percentile for each value in column F. A percentile is the va

Examples

Example 1

The PERCENTRANK function returns the relative standing of a value within a data set as a percentage. For example, a test score greater than 80% of all