The Excel PERCENTRANK.EXC function returns the relative rank of a value in a data set as a percentage representing how many values are less than or equal to the value. Percentile rank is commonly used as a way to interpret standing in standardized tests.

**Syntax**:= PERCENTRANK.EXC (array, x, [significance])

The PERCENTRANK.EXC function syntax has the following arguments:

**Array**Required. The array or range of data with numeric values that defines relative standing**X**Required. The value for which you want to know the rank.-
**Significance**Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).

**Example**: Let’s look at some Excel PERCENTRANK.EXC function examples and explore how to use the PERCENTRANK.EXC function as a worksheet function in Microsoft Excel:

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B2)

**Result**: 0.823

Based on the Excel spreadsheet above, the following PERCENTRANK.EXC examples would return:

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B3)

**Result**: 0.647

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B4)

**Result**: 0.058

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B5)

**Result**: 0.294

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B6)

**Result**: 0.529

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B7)

**Result**: 0.941

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B8)

**Result**: 0.235

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,9.3)

**Result**: 0.858

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,7.7)

**Result**: 0.382

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,8.8)

**Result**: 0.8

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B12,2)

**Result**: 0.05

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B13,2)

**Result**: 0.35

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B14,2)

**Result**: 0.64

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B15,1)

**Result**: 0.8

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B16,2)

**Result**: 0.6

**Syntax**: =PERCENTRANK.EXC($B$2:$B$17,B17,1)

**Result**: 0.4

**Note**:

- If x does not match one of the values in array, PERCENTRANK.EXC interpolates to return the correct percentage rank.
- If array is empty, PERCENTRANK.EXC returns the #NUM! error value.
- If significance < 1, PERCENTRANK.EXC returns the #NUM! error value.
- If x is smaller than the minimum, or greater than the maximum value in the supplied array, PERCENTRANK.EXC returns the #N/A error value.