Syntax
=PERCENTRANK(array, x, [significance])Arguments
| Argument | Required | Description |
|---|---|---|
array | Required | The numbers |
x | Required | The value to rank |
significance | Optional | Number of digits to keep (3 when left out) |
How to use PERCENTRANK
PERCENTRANK is kept so older workbooks keep working. It calculates the same way as PERCENTRANK.INC, which is the name to use in new formulas.
PERCENTRANK takes 2 required arguments and 1 optional argument. Type =PERCENTRANK( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=PERCENTRANK({13,12,11,8,4,3,2,1,1,1}, 4)Result Related compatibility functions
- NORMINVReturns the inverse of the normal distribution (older name of NORM.INV).
- NORMSDISTReturns the cumulative standard normal distribution (older form of NORM.S.DIST).
- NORMSINVReturns the inverse of the standard normal distribution (older name of NORM.S.INV).
- PERCENTILEReturns the k-th percentile of the values (older name of PERCENTILE.INC).
- POISSONReturns the Poisson distribution (older name of POISSON.DIST).
- QUARTILEReturns a quartile of the values (older name of QUARTILE.INC).
- RANKReturns the rank of a number in a list (older name of RANK.EQ).
- STDEVEstimates the standard deviation from a sample (older name of STDEV.S).
- STDEVPReturns the population standard deviation (older name of STDEV.P).