Returns the percentage rank (percentile) of a specified value in a dataset. Learn more
In Google Sheets, the PERCENTRANK function calculates the rank of a specified value within a dataset as a percentile.
The formula syntax for PERCENTRANK is as follows:
PERCENTRANK(data, value, [significant_digits])
data represents the range or array of values in which you want to calculate the percentile.
value is the value for which you want to determine the rank.
significant_digits specifies the number of significant digits for the percentile calculation. If omitted, it defaults to 3.
The PERCENTRANK function returns a decimal value between 0 and 1, representing the rank of the specified value in the dataset.
This value indicates the percentage of values in the dataset that are less than or equal to the specified value.
Here's an example to illustrate the usage of PERCENTRANK in Google Sheets:
=PERCENTRANK(A1:A10, 5, 2)
In this example, the formula calculates the percentile rank of the value 5 within the range A1:A10 with two significant digits.
The returned value will be a decimal representing the percentage rank of 5 compared to the other values in the dataset.