Formulas > =PERCENTILE()

How To Use PERCENTILE() Function in Google Sheets


Returns the value at a given percentile of a dataset.

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

Appropriate usage of the PERCENTILE formula:
  1. Calculating a specific percentile value within a data set.
  2. Analyzing and comparing data distributions.
  3. Identifying outliers or extreme values.
  4. Determining rankings based on percentiles.

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

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

Common pitfalls when using the PERCENTILE 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 percentiles (e.g., assuming a specific interpolation method).

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

Common misconceptions about the PERCENTILE formula:
  1. Assuming that the percentile value should always correspond to a specific data point in the set.
  2. Believing that the formula automatically sorts the data in ascending order.
  3. Thinking that the formula calculates the percentile 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 PERCENTILE() in Sheets

PERCENTILE(data, percentile)

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 PERCENTILE() 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 PERCENTILE() 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.