02:05:00
PERCENTRANK.EXC function
Syntax
PERCENTRANK.EXC(array,x,[significance])The PERCENTRANK.EXC
function syntax has the following arguments (argument: A value that provides
information to an action, an event, a method, a property, a function, or a
procedure.):
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).
Remarks
If array is empty, PERCENTRANK.EXC returns the #NUM! error
value.
If significance < 1, PERCENTRANK.EXC returns the #NUM!
error value.
If x does not match one of the values in array,
PERCENTRANK.EXC interpolates to return the correct percentage rank.
Example
