PERCENTRANK.INC
Returns the rank of a value in a data set as a percentage (0..1, inclusive)
Syntax
PERCENTRANK.INC(array, x, [significance])
Parameters
- array: Required. The array or range of data
- x: Required. The value for which you want to know the rank
- significance: Optional. The number of significant digits (default 3)
Example
=PERCENTRANK.INC(A1:A10, 8)