PERCENTRANK.EXC

PERCENTRANK.EXC(array, x [,significance])

Returns the percentage rank of a value in an array of numbers (exclusive).

arrayThe array of values.
xThe value for which you want to know the rank.
significance(Optional) The number of significant digits for the returned percentage value.

REMARKS
* This function was added in Excel 2010.
* If "array" is empty, then #NUM! is returned.
* If "significance" < 1, then #NUM! is returned.
* If "significance" is left blank", then 3 is used (i.e. 0.xxx%).
* If "x" does not match one of the values in array, the functions interpolates to return the correct percentage rank.
* You can use the PERCENTILE.EXC function to return the number corresponding to a particular percentage from an array of numbers (exclusive).
* You can use the PERCENTILE.INC function to return the number corresponding to a particular percentage from an array of numbers (inclusive).
* You can use the PERCENTRANK.INC function to return the percentage rank of a value in an array of numbers (inclusive).
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1) = 0.090
2=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},1.5) = 0
3=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},2) = 0.181
4=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},3) = 0.272
5=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},4) = 0.363
6=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},9) = 0.818
7=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},10) = 0.909
8=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},15) = #N/A
9=PERCENTRANK.EXC({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top