How to Use Excel PERCENTRANK Function in Office 365?
Tags: excelfunctions, excelpercentrankfunc
Published: 2020-09-18 13:44:29

---
title: How to Use Excel PERCENTRANK Function in Office 365?
published: true
date: 2020-09-18 11:17:25 UTC
tags: ExcelFunctions,ExcelPERCENTRANKFunc
canonical_url: https://geekexcel.com/how-to-use-excel-percentrank-function-in-office-365/
---

## PERCENTRANK Function:

![PERCENTRANK Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_8niNFgTwpf.png)<figcaption id="caption-attachment-14203">PERCENTRANK Function</figcaption>

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](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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_qkC8kPeoA5.png)<figcaption id="caption-attachment-14222">Function Behavior</figcaption>

## 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**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the array is empty, it will return **[#NUM! Error](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).**
- If any of the arguments are non-numeric values such as **letters** and **symbols** and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-69.png)<figcaption id="caption-attachment-14193">Example 1</figcaption>

### Example 2:

- If the **significance is less than 1** and then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-64.png)<figcaption id="caption-attachment-14194">Example 2</figcaption>

### Example 3:

- If any of the arguments are non-numeric values such as **letters** and **symbols** and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-27.png)<figcaption id="caption-attachment-14195">Example 3</figcaption>

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.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**PERCENTRANK.EXC Function**](https://geekexcel.com/how-to-use-excel-percentrank-exc-function-in-office-365/)
- [**PERCENTRANK.INC Function**](https://geekexcel.com/how-to-use-excel-percentrank-inc-function-in-office-365/)

### See Also:

- [How to Use Excel PERMUT Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-permut-function-in-office-365-with-examples/)
- [How to Use Excel AVERAGEIF Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-averageif-function-in-office-365-with-examples/)