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

This function can be used to evaluate 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.

PERCENTRANK.INC takes 3 required arguments and no optional arguments:

Syntax: PERCENTRANK.INC(array, x, significance)

The arguments for the PERCENTRANK.INC function are:
Argument Required? Description
array Required The array or range of data with numeric values that defines relative standing.
x Required The value for which you want to know the rank.
significance Required A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (
comments powered by Disqus