# How to calculate a percentile in Excel

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

**Excel:** `=PERCENTILE.INC(B2:B11,0.9)` (Excel 2010 and later)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E |
| --- | --- | --- | --- | --- |
| Order | Minutes |  | Percentile | Value |
| #1 | 34 |  |  |  |
| #2 | 38 |  |  |  |
| #3 | 41 |  |  |  |
| #4 | 29 |  |  |  |
| #5 | 36 |  |  |  |
| #6 | 44 |  |  |  |
| #7 | 39 |  |  |  |
| #8 | 31 |  |  |  |
| #9 | 95 |  |  |  |
| #10 | 35 |  |  |  |

Formula in G2: `=PERCENTILE.INC(B2:B11,0.9)`

Result: 49.1

## 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!.

## Other ways

- `=QUARTILE.INC(B2:B11,3)`: 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.

## 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.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-11-20.

Source: https://spreadsheetpractice.com/formulas/calculate-a-percentile
