PERCENTRANK.EXC function
Summary
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
Syntax
PERCENTRANK.EXC(array,x,[significance])
The PERCENTRANK.EXC function syntax has the following arguments:
• 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 Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).
• 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 Optional. A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.EXC uses three digits (0.xxx).
Example
=PERCENTRANK.EXC(A2:A10, 7)
=PERCENTRANK.EXC(A2:A10,5.43)
=PERCENTRANK.EXC(A2:A10,5.43,1)
=PERCENTRANK.EXC(A2:A10,5.43)
=PERCENTRANK.EXC(A2:A10,5.43,1)