The Excel Percentrank.Exc function computes the relative position of a provided value within an array, between 0 and 1 (exclusive).
Syntax :
=PERCENTRANK.EXC( array, x, [significance] )
Parameters :
Example :
Cells B1-B4 in the worksheet below demonstrate Excel Percentrank examples. Exc Function, which is used to determine the relative position of four distinct values inside the array of values in cells A1-A9.
Ask Your Query