Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate a percentile in Excel and Google Sheets
Topic:RANK & statistical aggregatesHeads up: Excel and Google Sheets do this differently.
Excel
=PERCENTILE.INC(B2:B6,0.75)Google Sheets
=PERCENTILE(B2:B6,0.75)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select the output cell.
- 2In Excel, type =PERCENTILE.INC(B2:B6,0.75) for the 75th percentile.
- 3In Google Sheets, type =PERCENTILE(B2:B6,0.75) — it is equivalent to PERCENTILE.INC.
- 4The second argument is a decimal between 0 and 1 (e.g. 0.9 for 90th percentile).
- 5Press Enter.
Tips
- PERCENTILE.INC allows 0 and 1 as valid percentile arguments; PERCENTILE.EXC requires values strictly between 0 and 1.
- The legacy PERCENTILE function in Excel behaves like PERCENTILE.INC.
- Google Sheets PERCENTILE is equivalent to PERCENTILE.INC.
- For quartiles, use QUARTILE.INC(range, 1) for Q1, QUARTILE.INC(range, 3) for Q3.
Need the Google Sheets version instead? Open Sheets variant in workspace →
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is the difference between PERCENTILE.INC and PERCENTILE.EXC?
PERCENTILE.INC includes the 0th (minimum) and 100th (maximum) percentiles. PERCENTILE.EXC excludes them and is useful when those extremes are considered outside the valid range.
How do I calculate quartiles?
Use QUARTILE.INC(range, quart) where quart is 1, 2, or 3 for Q1, Q2, Q3. Q2 equals the median.
More on RANK & statistical aggregates
See all →Reference
RANK.EQ
Returns the rank of a number in a list, assigning the same rank to ties (same as RANK). Essential for leaderboards.
How-toHow to rank values
Rank a number against a list with RANK — highest first or lowest first. Works the same in Excel and Google Sheets.
ReferenceRANK.AVG
Returns the rank of a number, averaging ranks for ties. Useful in statistical analysis where tied ranks should not cluster.
How-toHow to calculate standard deviation
Measure how spread out your numbers are with STDEV for a sample or STDEVP for a whole population. Works in Excel and Google Sheets.
ReferencePERCENTILE
Returns the k-th percentile value from a dataset. Useful for performance benchmarking and threshold analysis.
How-toHow to calculate a weighted average
Combine values and their weights with SUMPRODUCT divided by the total weight. Works the same in Excel and Google Sheets.