In this article:

PERCENTRANK in Google Sheets (Easiest Way to Use It in 2024)

May 8, 2024

PERCENTRANK in Google Sheets

PERCENTRANK in Google Sheets is a function used to find the rank of a value in a data set as a percentage of the data set. This function gives you the relative standing of a specific value within a data array, which can be particularly useful in statistical analysis for understanding how a particular value compares against the entire data set.


The syntax for PERCENTRANK function is as follows:

PERCENTRANK(data, value, [significance])

  • data: The array or range containing the dataset to consider.
  • value: The value for which you want to find the percentile rank.
  • [significance]: (Optional) The number of significant digits for the returned percentage value. If omitted, Google Sheets uses 3 significant digits.

The function returns the percentile rank of the value within the data set, represented as a decimal number between 0 and 1. For example, if the function returns 0.9, it means that the value is at or above 90% of the other values in the dataset.

How to Use the Google Sheets PERCENTRANK

Follow the steps below to use the Google Sheets PERCENTRANK. 

1. Input Your Data

Input the dataset with test scores in column B, starting from B2 to B11, for each student's score.

percentrank google sheets

2. Select the Cell for PERCENTRANK Result

Choose an empty cell where you want the percentile rank of a specific score to appear. This cell will contain your formula.

3. Enter the PERCENTRANK Formula and Specify the Data Range and Value

In the selected cell, type ‘=PERCENTRANK(B2:B11, value)’ to calculate the percentile rank. Replace value with the specific score you're analyzing. For example, to find the percentile rank of the score 88, you'll use ‘=PERCENTRANK(B2:B11, B2)’. This step combines specifying the formula, defining the data range as B2:B11, and identifying the specific value to rank.

4. Press Enter and View the Result

Press Enter to execute the formula. The cell will display the percentile rank of the specified score. To apply the formula to other scores, click on the cell with your formula, then drag the fill handle down to the rows you wish to analyze.

5. Analyze the Results

With the calculated percentile ranks, you can now analyze how each score compares within the dataset. For instance, if a test score of 88 yields a percentile rank of 0.556, it means this score is higher than approximately 55.6% of the other scores in the dataset. This analysis can help in understanding the relative performance of students or the distribution of scores in your dataset.

We hope that you now have a better understanding of what PERCENTRANK is in Google Sheets and how to use the Google Sheets PERCENTRANK. If you enjoyed this article, you might also like our article on how to use the future value formula in Google Sheets or our article on how to use DGET in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->