# PERCENTRANK.INC function in Excel

> PERCENTRANK.INC tells you where a value stands in a list, from 0 for the lowest to 1 for the highest: 0.75 means it is above 75% of the other values.

Source: https://spreadsheetpractice.com/functions/percentrank-inc · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on October 30, 2026

## Quick answer

- **What it does:** PERCENTRANK.INC tells you where a value stands in a list, from 0 for the lowest to 1 for the highest: 0.75 means it is above 75% of the other values.
- **Syntax:** `=PERCENTRANK.INC(array, x, [significance])`
- **Most common use:** `=PERCENTRANK.INC(A2:A11,8)` returns 0.666 (6 of the other 9 values are lower: 0.666 (truncated))
- **Available in:** Excel 2010 and later
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** A number from 0 to 1; #N/A if x is below the smallest or above the largest value.
- **Google Sheets:** Google Sheets has PERCENTRANK.INC and PERCENTRANK.

## What it does

PERCENTRANK.INC tells you where a value stands in a list, from 0 for the lowest to 1 for the highest: 0.75 means it is above 75% of the other values. Values between list entries are interpolated, and the result is cut to three decimals unless you ask for more. Use it to turn scores or sales into percentile standings. PERCENTRANK is the older name.

## Syntax

`=PERCENTRANK.INC(array, x, [significance])`

| Argument | Required? | What it is |
|---|---|---|
| `array` | Required | The list of numbers to rank against. |
| `x` | Required | The value to rank. |
| `significance` | Optional | Optional: decimal places to keep; 3 if omitted. The result is truncated, not rounded. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| C2 | `=PERCENTRANK.INC(A2:A11,8)` | 0.666 | 6 of the other 9 values are lower: 0.666 (truncated) |
| C3 | `=PERCENTRANK.INC(A2:A11,5)` | 0.583 | 5 isn't in the list, so it's interpolated between 4 and 8 |
| C4 | `=PERCENTRANK.INC(A2:A11,8,1)` | 0.6 | One decimal place: 0.6 |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C |
|---|---|---|---|
| 1 | Value |  | Result |
| 2 | 13 |  | 0.666 |
| 3 | 12 |  | 0.583 |
| 4 | 11 |  | 0.6 |
| 5 | 8 |  |  |
| 6 | 4 |  |  |
| 7 | 3 |  |  |
| 8 | 2 |  |  |
| 9 | 1 |  |  |
| 10 | 1 |  |  |
| 11 | 1 |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| #N/A | x is lower than the smallest or higher than the largest value in the list. |
| 0.666 instead of 0.667 | PERCENTRANK.INC truncates to the decimals in significance instead of rounding. |
| Text or blanks in the list | Only numbers count. Text and blank cells are skipped. |

## Tips

- Format the result as a percentage to read 0.666 as 66.6%.

## Related functions

- [RANK.EQ](https://spreadsheetpractice.com/functions/rank-eq): RANK.EQ tells you where a number places within a list: 1 for the largest by default, or 1 for the smallest if you set the order to 1.
- [PERCENTILE.INC](https://spreadsheetpractice.com/functions/percentile-inc): PERCENTILE.INC returns the value below which a given share of the data falls: k = 0.9 gives the 90th percentile.
- [QUARTILE.INC](https://spreadsheetpractice.com/functions/quartile-inc): QUARTILE.INC returns a quartile of a set of numbers: 1 for the first quartile (the 25th percentile), 2 for the median, 3 for the third quartile, and 0 and 4 for the minimum and maximum.

## Questions

### How do I calculate percentile rank in Excel?

=PERCENTRANK.INC($B$2:$B$100,B2) gives B2's standing in the list from 0 to 1. Fill it down for every row.

### How is PERCENTRANK different from RANK?

RANK gives a position: 1st, 2nd and so on. PERCENTRANK gives a share from 0 to 1, so it compares across lists of different sizes.

## Practice

A graded PERCENTRANK.INC exercise ("Sales standing") is on [the PERCENTRANK.INC page](https://spreadsheetpractice.com/functions/percentrank-inc). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.