DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to Use Excel PERCENTRANK Function in Office 365?

PERCENTRANK Function:

PERCENTRANK Function
PERCENTRANK Function

In this tutorial, we will guide you to learn the usage of Excel PERCENTRANK Function in Office 365 with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

PERCENTRANK Function – Explanation:

  • 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, they are PERCENTRANK.INC and PERCENTRANK.EXC Functions. The difference between these functions is given in the below table.

Function Behavior
Function Behavior

Syntax:

=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:

  • If the significance is less than 1 and then this function returns #NUM! Error.
  • If the array is empty, it will return #NUM! Error.
  • 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 hot PERCENTRANK Function works.

Example 1:

  • In this screenshot, you can be able to see the input range in Column A , and its corresponding PERCENTRANK values are displayed in Column C.

Example 1
Example 1

Example 2:

  • If the significance is less than 1 and then this function returns #NUM! Error.

Example 2
Example 2

Example 3:

  • If any of the arguments are non-numeric values such as letters and symbols and then this function returns #VALUE! Error.

Example 3
Example 3

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 Excel PERCENTRANK Function in Office 365 with its syntax, explanation, and examples. Leave your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!!

Similar Functions:

See Also:

Top comments (0)