PERCENTRANK.INC function
Summary
Returns the percentage rank of a value in a data set
Syntax
PERCENTRANK.INC(array,x,[significance])
The PERCENTRANK.INC 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.INC 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.INC uses three digits (0.xxx).
Example
=PERCENTRANK.INC(A2:A11,2)
=PERCENTRANK.INC(A2:A11,4)
=PERCENTRANK.INC(A2:A11,8)
=PERCENTRANK.INC(A2:A11,5)
=PERCENTRANK.INC(A2:A11,4)
=PERCENTRANK.INC(A2:A11,8)
=PERCENTRANK.INC(A2:A11,5)