Formulas > =PERCENTRANK()

How To Use PERCENTRANK() Function in Google Sheets


Returns the percentage rank (percentile) of a specified value in a dataset.

Common questions about the PERCENTRANK formula in Google Sheets:
  1. What does the PERCENTRANK formula do?
  2. How do I use the PERCENTRANK formula in Google Sheets?
  3. What arguments does the PERCENTRANK formula require?
  4. Can the PERCENTRANK formula handle non-numeric values or errors?
  5. How do I interpret the result of the PERCENTRANK formula?
  6. Are there any limitations or restrictions when using the PERCENTRANK formula?

Appropriate usage of the PERCENTRANK formula:
  1. Calculating the rank of a specific value within a data set.
  2. Comparing the relative position of a value with respect to other values in a range.
  3. Analyzing the distribution of data by determining the percentile rank of a value.
  4. Identifying the percentage of values that are lower than a given value.

Common mistypings of the PERCENTRANK formula:
  1. Misspelling the formula name as "PERCENTRANC" or "PERCENRANK".
  2. Incorrectly specifying the range or array of values.
  3. Using the wrong syntax or order of arguments.

Inappropriate usage of the PERCENTRANK formula:
  1. Applying the formula to a small data set with insufficient data points.
  2. Using the formula with non-numeric values or text strings.
  3. Misinterpreting the rank value or comparing ranks across different data sets.

Common pitfalls when using the PERCENTRANK formula:
  1. Failing to sort the data set in ascending order before applying the formula.
  2. Overlooking missing or invalid values, which can affect the results.
  3. Using an incorrect method for calculating percent ranks (e.g., assuming a specific interpolation method).

Common mistakes when using the PERCENTRANK formula:
  1. Forgetting to provide the value to be ranked as the first argument.
  2. Neglecting to include the range or array of values as the second argument.
  3. Using an incorrect range reference or mistakenly excluding data points.

Common misconceptions about the PERCENTRANK formula:
  1. Assuming that the rank value corresponds to a specific position in the sorted data set.
  2. Believing that the formula automatically sorts the data in ascending order.
  3. Thinking that the formula calculates the percentile rank based on the total number of values rather than the position within the sorted data set.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

How To Actually Use PERCENTRANK() in Sheets

PERCENTRANK(data, value, [significant_digits])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the PERCENTRANK() formula:

Rank, Percentrank, & Percentile Functions

This video is part of the series on Statistical Functions. More videos and tutorials about spreadsheet learning can be found at Please select the HD quality setting when viewing this video in full-screen mode.

Generate a PERCENTRANK() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.