Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
PERCENTRANK
PERCENTRANK (also PERCENTRANK.INC) returns a number between 0 and 1 indicating what fraction of values in the array are less than or equal to the given value. It is the inverse of PERCENTILE and is used to benchmark individual scores against a distribution.
Excel
=PERCENTRANK(B2:B5,210)Google Sheets
=PERCENTRANK(B2:B5,210)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply the data range and the value to rank: =PERCENTRANK(B2:B5,210).
- 2The result is a decimal between 0 and 1; multiply by 100 for a percentage.
- 3Values at the minimum return 0; values at the maximum return 1.
Need a version for your data?
Try: “Show what percentile rank a specific test score sits at within the full class results”