Edit

Share via


WorksheetFunction.PercentRank_Exc(Object, Double, Object) Method

Definition

Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.

public double PercentRank_Exc (object Arg1, double Arg2, object Arg3);
Public Function PercentRank_Exc (Arg1 As Object, Arg2 As Double, Optional Arg3 As Object) As Double

Parameters

Arg1
Object

Array - The array or range of data with numeric values that defines relative standing.

Arg2
Double

X - The value for which you want to know the rank.

Arg3
Object

Significance - A value that identifies the number of significant digits for the returned percentage value. If omitted, PercentRank_Exc uses three digits (0.xxx).

Returns

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.

Applies to