Sample usage
PERCENTRANK.EXC(A1:A100, A2, 4)
PERCENTRANK.EXC(A1:A100, 10)
Syntax
PERCENTRANK.EXC(data, value, [significant_digits])
data
– The array or range containing the data set to consider.value
– The value whose percentage rank will be determined.significant_digits
– [ OPTIONAL – 3 by default ] – The number of significant figures to be used in the calculation.
Notes
- If the
value
does not fall within the data given for the function, an estimation will be made to bring up a percentage rank for that value.
See also
PERCENTRANK
: Returns the percentage rank (percentile) of a specified value in a data set.
PERCENTRANK.INC
: Returns the percentage rank (percentile) from 0 to 1, inclusive of a specified value in a data set.
PERCENTILE
: Returns the value at a given percentile of a data set.
LARGE
: Returns the nth largest element from a data set, where n is user-defined.
MIN
: Returns the minimum value in a numerical data set.
MAX
: Returns the maximum value in a numerical data set.
MEDIAN
: Returns the median value in a numerical data set.