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

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

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.
* This function replaces the PERCENTRANK function.
* 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.
* For the Microsoft documentation refer to support.office.com

 A
1=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},1) = 0.000
2=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},1.5) = 0
3=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},2) = 0.111
4=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},3) = 0.222
5=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},4) = 0.333
6=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},9) = 0.888
7=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},10) = 1.000
8=PERCENTRANK.INC({2,4,6,8,10,12,14,16},7) = 0.357
9=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},15) = #N/A
10=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},"some text") = #VALUE!
11=PERCENTRANK.INC({1,2,3,4,5,6,7,8,9,10},2) = 0

1 - What is the rank (as a percentage) of the number

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