81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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 bettersheets.co/formulas, 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 Use in Sheets

PERCENTILE(data, percentile)

External Links

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 www.spreadsheetsolving.com. Please select the HD quality setting when viewing this video in full-screen mode.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.