PERCENTRANK Function in Excel: Syntax, Examples and Free Practice
PERCENTRANK is an Excel Compatibility function. Legacy percentage rank formula — kept for compatibility with older files.
PERCENTRANK syntax
Arguments
array: The range or array to evaluatex: The value to evaluatesignificance: The multiple to round to (optional)
When to use PERCENTRANK
PERCENTRANK is kept mainly for opening older files built in earlier versions of Excel.
Practice PERCENTRANK online, free
Open the live Excel-style spreadsheet and try PERCENTRANK yourself. No Excel install or sign-up needed to start.
Practice PERCENTRANK now →More Compatibility functions
- BETADIST
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
Frequently asked questions
What does the PERCENTRANK function do in Excel?
Legacy percentage rank formula — kept for compatibility with older files.
What is the syntax of PERCENTRANK in Excel?
The syntax is =PERCENTRANK(array, x, [significance]). array: The range or array to evaluate; x: The value to evaluate; significance: The multiple to round to (optional).
Where can I practice PERCENTRANK online for free?
Open the free live spreadsheet on Cellgrids and try PERCENTRANK yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts