Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
PERCENTRANK
The PERCENTRANK function returns the rank of a value in a set as a percentage of the set.
PERCENTRANK(value-set, value, significance)
value-set: A collection that must contain number values, date/time values, or duration values. All values must be of the same value type.
value: The single number value, date/time value, or duration value to be ranked. value must be of the same value type as the values contained in value-set.
significance: An optional number value specifying the number of digits to the right of the decimal point. significance must be greater than or equal to 1. If omitted, a default value of 3 is used (x.xxx%).
Notes
PERCENTRANK can be used to evaluate the relative standing of a value within a collection. It is calculated by determining where in the collection a specified number falls. For example, if in a given collection, there are ten values smaller than a specified number and ten values that are larger, the PERCENTRANK of the specified number is 50%.
Example |
|---|
Suppose cells B2 through J2 contain the values 5, 6, 9, 3, 7, 11, 8, 2, and 14, respectively. The rank of the number 10 can be found with the formula: =PERCENTRANK(B2:J2, 10) returns approximately 0.813, because there are seven values smaller than 10 and only two that are larger. |