fx =PERCENTILE(A1:A100,0.9)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

PERCENTILE Formula for Statistical

Find the value at a given percentile. Copy-paste ready for Excel, Google Sheets, and Airtable.

=PERCENTILE(A1:A100,0.9)
When you need this: When you analyze website load times (A1:A100) and need the 90th percentile — what time is "slow" for top 10%?

How it works

  1. 1PERCENTILE finds the value below which a percentage of data falls.
  2. 20.9 = 90th percentile (90% of values are below this point).
  3. 3Useful for SLAs, performance targets, and detecting outliers.

Variations

Find 50th percentile (median)
=PERCENTILE(A1:A100,0.5)
Find 95th percentile
=PERCENTILE(A1:A100,0.95)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →