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

* 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.
* In Excel 2010 the function PERCENTRANK.INC can be used to handle the percentile value in an inclusive range of 0..1.
* For the Microsoft documentation refer to support.office.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!

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