Find the value below which a given percentage of the data falls.
Copy this formula
=PERCENTILE.INC(A2:A100, 0.9)PERCENTILE.INC returns the value at a percentile (0.9 = 90th). It's used for SLAs, grading curves, and spotting top or bottom thresholds. Use 0.25 and 0.75 for quartiles.
=PERCENTILE.INC(ResponseTimes, 0.95)→42095% of responses are at or under 420 ms.
Rank a value as a percentile
=PERCENTRANK.INC(A2:A100, B2)Returns where a value sits, as a percentile.
.INC includes the 0th and 100th percentiles; .EXC excludes them and needs more data points.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.