How to Use Excel PERCENTRANK.INC Function in Office 365?
Tags: excelfunctions, excelpercentrankincf
Published: 2020-09-18 13:44:45

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

## PERCENTRANK.INC Function:

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

In this guide, we are going to see the usage of **Excel PERCENTRANK.INC Function in Office 365** 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](https://www.microsoft.com/en-in/microsoft-365/excel)

## **PERCENTRANK.INC 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 similar to the **PERCENTRANK**  **Function.**
- 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.INC(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.224** ).

## Examples:

Let’s see some examples to understand this concept easily.

### 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-71.png)<figcaption id="caption-attachment-14213">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-66.png)<figcaption id="caption-attachment-14214">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-29.png)<figcaption id="caption-attachment-14215">Example 3</figcaption>

## Wind-Up:

In this guide, you can clearly understand the usage of **Excel PERCENTRANK.INC Function in Office 365** with its syntax, explanation, and examples. Give your **suggestions** 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 Function**](https://geekexcel.com/how-to-use-excel-percentrank-function-in-office-365/)

### Read Ahead:

- [How to Use Excel STDEVPA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdevpa-function-in-office-365-with-examples/)
- [How to Use Excel LARGE Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/)