May 9, 2021

# How to use PERCENTRANK.EXC Function in Excel

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.
READ:  How to use FORECAST.LINEAR Function in Excel

#### Excel

View all posts by Excel →