Spreadsheet Practice

How to calculate a percentile in Excel

Formula (Excel and Google Sheets)

=PERCENTILE.INC(B2:B11,0.9)

Use =PERCENTILE.INC(range, k) where k is a fraction from 0 to 1. For the 90th percentile, =PERCENTILE.INC(B2:B11,0.9).

Result on the example
49.1 in G2
Works in
Excel 2010 and later
Google Sheets
Same formula

See it work

The formula is already in G2. Change any input and the result updates, or edit the formula to experiment.

How it works

The 90th percentile is the value that 90% of the data falls at or below. Service targets are often written this way: "90% of deliveries arrive within 45 minutes".

The second argument is a fraction, so 90% is 0.9, not 90. Typing 90 returns #NUM!.

=PERCENTILE.INC(B2:B11,0.9)

Result49.1

  1. B2:B1110 rows × 1 col: 34, 38, 41, 29, …

    A range: 10 cells in one column.

  2. PERCENTILE.INC(B2:B11,0.9)49.1

    PERCENTILE.INC: The value at percentile k (0 to 1), interpolating between values. PERCENTILE is the older name.

    • arrayB2:B1110 rows × 1 col: 34, 38, 41, 29, …
    • k0.9

In Google Sheets

The same formula works in Google Sheets: =PERCENTILE.INC(B2:B11,0.9). We ran it in Google Sheets mode on the same data and it returns 49.1.

Other ways to do it

Each one was run on the same example sheet.

FormulaResultWhen to use it
=QUARTILE.INC(B2:B11,3)40.5Different resultThe 75th percentile is the same as Q3. Gives the 75th percentile, not the 90th. Shown only to connect the two functions.

Common mistakes

  • k must be between 0 and 1. =PERCENTILE.INC(B2:B11,90) gives #NUM!; use 0.9 or 90%.
  • To find the percentile of a value instead (what share of the data sits below it), use PERCENTRANK.INC.

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Calculate a percentile

In G2, find the 90th percentile of the delivery minutes in B2:B11.

Questions

How do I find what percentile a value is in?

Use =PERCENTRANK.INC(B2:B11,B5), which returns the value's position as a fraction from 0 to 1.

Checked by running on 2026-11-20: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.