** **The Excel** PERCENTRANK.INC** Function calculates the relative position between 0 and 1 inclusive,within a supplied array.In MS Excel **PERCENTRANK.INC** is categorized under statistical function.

## Purpose of Excel PERCENTRANK.INC Function

To get the relative standing of a value within a data set. For example, you can use **PERCENTRANK.INC** to evaluate the standing of an aptitude test score among all scores for the test.

## Return value

PERCENTRANK.INC returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.

## Syntax

= PERCENTRANK.INC(array,x,[significance])

## Arguments

Arguments | Description | Remarks |

array | A range or array from which you want to return the rank. | Mandatory |

x | The value that you wish to find the rank for. | Mandatory |

[significance] | Number of significant digits in result. Defaults to 3. | Optional |

## Usage notes

- N/A error will Occur if the supplied value of x is smaller than the minimum, or greater than the maximum value in the supplied array.
- NUM!error will occur if the supplied [significance] value is < 1.
- NUM!error will occur if the supplied array is empty.

### Availability

Since 2010 for Windows.

Since 2011 for Mac.