How to Use Excel PERCENTRANK.EXC Function in Office 365?
Tags: excelfunctions, excelpercentrankexcf
Published: 2020-09-18 13:45:03

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

## PERCENTRANK.EXC Function:

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

In this post, we are going to explore how to use the **Excel PERCENTRANK.EXC 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.EXC Function – Description:**

- This function **returns the rank of a value in a data set as a percentage of the data set exclusive of first and last values**.
- It can be used to evaluate the relative standing of a value within a data set.
- The below image has shown the function behavior of the related functions.

![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.294** ).

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

Here are examples to help you to understand this function clearly.

### 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-70.png)<figcaption id="caption-attachment-14205">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-65.png)<figcaption id="caption-attachment-14206">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-28.png)<figcaption id="caption-attachment-14207">Example 3</figcaption>

From the above examples, you can clearly understand how to use **PERCENTRANK.EXC** Function.

## Closure:

In this post, you can learn the usage of **Excel PERCENTRANK.EXC Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

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

### Read Also:

- [How to Use Excel PERCENTILE Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-percentile-function-in-office-365-with-examples/)
- [How to Use Excel MODE.SNGL Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-mode-sngl-function-in-office-365-with-examples/)