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
B2:B1110 rows × 1 col: 34, 38, 41, 29, …A range: 10 cells in one column.
PERCENTILE.INC(B2:B11,0.9)49.1PERCENTILE.INC: The value at percentile k (0 to 1), interpolating between values. PERCENTILE is the older name.- array
B2:B1110 rows × 1 col: 34, 38, 41, 29, … - k
0.9
- array
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.
| Formula | Result | When to use it |
|---|---|---|
| =QUARTILE.INC(B2:B11,3) | 40.5Different result | The 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
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.