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.
| Function | Behavior | Inclusive/Exclusive |
|---|---|---|
| PERCENTRANK | It will find the percentage rank inclusive of the first and last values in the array. | Inclusive |
| PERCENTRANK.EXC | It will find the percentage rank exclusive of the first and last values in the array. | Exclusive |
| PERCENTRANK.INC | It will find the percentage rank inclusive of the first and last values in the array. | Inclusive |
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 Enter 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 Enter 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.
See Also:
- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?
Deepak is an Excel enthusiast and data analyst with over 5 years of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!
