The PERCENTRANK() function returns the rank of a value as a percentage of the values in the data set that fall below it. The syntax for the function is PERCENTILE (array, x, significance). The argument "array" can be numerical values, references to a range of cells or a named range of which you want to find the percentrank. "x" is the value with which you wish to make th ecomparison and "significance" is the number of signiifcant figures to which the percentage rank will be calcualted (Which must be between and 1. The percentage rank describes the relative number of the values that fall below the chosen value compared to the total number of values in the data set. For example: PERCENTRANK({1,2,3,4,5,6,7,8,9,10},5,1) = 0.4 As 4 values are smaller than the number 4, 6 values are equal or abover and 4/10=0.4 Note: If the chosen comparison value "x" does not match a data value in the array the PERCENTRANK function will interpolate to an appropriate percentage rank.

How to use the PERCENTRANK() function: Type " =PERCENTRANK( " Enter the reference for the array of data "A2:A10". Type a comma. Enter the "x" value "0.2". Type a comma. Enter the number of significant figures to be returned. Type")" then press the "Enter" key.

Note: To see the returned result as a percentage reformat the cell to display percentages. In the main menu go to Format > Cells, in the format cells window select "Percentage" form the category menu and press the "OK" button. [How to display numbers as percentages] If the "significance" is equal to or below zero the PERCENTRANK function will return a #NUM error to the cell.