Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
PERCENTILE
PERCENTILE (also PERCENTILE.INC) returns the value at the specified percentile rank within a range, where k is between 0 and 1 inclusive. Use it to find cutoff scores, salary benchmarks, or response-time thresholds.
Topic:RANK & statistical aggregatesExcel
=PERCENTILE(B2:B5,0.75)Google Sheets
=PERCENTILE(B2:B5,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
How it works
- 1Supply the data range and a percentile between 0 and 1: =PERCENTILE(B2:B5,0.75).
- 20.5 returns the median, 0.75 the 75th percentile, 0.9 the 90th, and so on.
- 3The function interpolates between data points when needed to return the exact percentile value.
Need a version for your data?
Try: “Find the 90th percentile response time from a column of load-test results”
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.
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.
How-toHow to calculate standard deviation
Use STDEV.S for a sample or STDEV.P for a full population to measure the spread of values around the mean.