How to Use Excel PERCENTRANK Function?

PERCENTRANK Function: We all know that Excel is a powerful spreadsheet program for performing various calculations. If you want to find out the rank of a value from the range of data in the worksheet, then we suggest you use the Excel PERCENTRANK function. You can apply this function easily on your worksheet.

In this tutorial, we will guide you to learn the usage of Excel PERCENTRANK Function with its syntax, explanation, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Explanation of PERCENTRANK Function

• This function returns the rank of a value in a data set as a percentage of the data set inclusive of first and last values.
• It can be used to evaluate the relative standing of a value within a data set.
• This function is replaced by two functions, which are PERCENTRANK.INC and PERCENTRANK.EXC Functions. The difference between these functions is given in the below table.

Syntax

• Here, you will see the syntax of the PERCENTRANK function.
• To apply this function on your spreadsheet, you must select a cell and enter the formula in the following format.
• Once you enter the formula, click the button to get the result.

=PERCENTRANK(array, x, [significance])

Arguments Explanation:

• Array – It is the input array or range of data.
• x – The input value for which you want to know the rank.
• Significance – It is an optional one. This argument represents the number of significant digits for the returned percentage value. If it is omitted, it will take three digits by default (For example, 0.234).

Note:
1) If the significance is less than 1 and then this function returns #NUM! Error.
2) If the array is empty, it will return #NUM! Error.
3) If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

Examples

Let’s see some examples to understand how PERCENTRANK Function works in the spreadsheet.

• Initially, you must open your Excel workbook on your PC and launch the worksheet with data.
• For instance, we have given the input range in Column A, and we will get the rank of a value in a data set using the PERCENTRANK function.
• Then, you must enter the formula in the cell below to get the result.
• After entering the formula, you need to click the  button to get the output.
• Once you get the output for the first cell, you have to drag down that cell to fill in the remaining values as shown in the below image.
• If the significance is less than 1 and then this function returns #NUM! Error.
• If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

From the above examples, you can learn how to use the PERCENTRANK Function easily.

Summary

In the above article, you can learn the usage of the Excel PERCENTRANK Function with its syntax, explanation, and examples. Leave your feedback in the comment section. To learn more about Excel functions, then visit our webpage, Aawexcel.com.

Video Tutorial

You can use the following video to know how to apply the Excel PERCENTRANK function in the spreadsheet.