Description Computes the percent rank of a specified value in a specified array of numbers.
Syntax RANK (array, number [, digits])
| Argument | Description |
|---|---|
| array | A list of at least 2 numbers, in the form of a range reference or array constant. Text and logical values are ignored. |
| number | The number you want ranked. It must be within the range of values in array.Text in the argument list that converts to a number will be evaluated as a number; otherwise the function will return the #VALUE! error. Text referenced in cells will return the #VALUE! error. Logical values are evaluated as 1 if TRUE and 0 if FALSE. |
| [digits] | Optional. The number of decimal digits you want the answer to be rounded to. It must be a numeric value between 1 and 308. If this argument is omitted, 3 is used. |
Remarks To determine percent rank, the function sorts array in ascending order. Then the function assigns a percent rank to each number in array: the lowest number is 0% rank, the highest number is 100% rank, and the middle number is 50% rank.
If number is in array, the function returns the percent rank assigned to number.
If number is not in array, the function calculates the percent rank that falls proportionately between the percent ranks above and below number.
This function is the inverse of the PERCENTILE function.
Examples This function returns .5:
This function returns .375:
See Also PERCENTILE, QUARTILE, RANK
