Quick Navigation
PERCENTRANK.INC Function
Summary
The PERCENTRANK.INC function calculates the relative position of a specific value within a dataset, expressed as a percentage between 0 and 1 (inclusive). Perfect for percentile rankings in performance metrics, test scores, or any comparative analysis.
Syntax
PERCENTRANK.INC(array,x,[significance])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| array | Range/Array |
Yes | The dataset containing numeric values for ranking |
| x | Number |
Yes | The value to rank within the dataset |
| significance | Number |
No | Number of decimal places for the result (defaults to 3) |
Using the PERCENTRANK.INC Function
PERCENTRANK.INC helps determine how a value compares to others in a dataset. Use it to rank sales performance, exam scores, or any metric where relative standing matters. The function interpolates between data points for accurate percentage calculations.
Common PERCENTRANK.INC Examples
Basic Percentile Ranking
=PERCENTRANK.INC(A2:A11,2)Ranks value 2 in dataset (returns 0.333 as 3 values are smaller)
Midpoint Interpolation
=PERCENTRANK.INC(A2:A11,5)Ranks value 5 between 4 and 8 (returns 0.583 via interpolation)
Custom Precision
=PERCENTRANK.INC(A2:A11,4,4)Ranks value 4 with 4 decimal places precision
Sales Performance
=PERCENTRANK.INC(SalesRange,D5)Shows salesperson's percentile rank among team
Frequently Asked Questions
Common Errors and Solutions
#NUM!
Cause: Array is empty or significance < 1
Solution: Ensure array has numeric data and significance ≥ 1
#VALUE!
Cause: Non-numeric data in array or x parameter
Solution: Verify all inputs contain valid numbers
Notes
- Interpolates between data points for precision
- Perfect for performance evaluations
- Use with PERCENTILE.INC for comprehensive analysis
- Returns decimal percentage (multiply by 100 for % format)
Compatibility
Available in: Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2007, Excel 2003, Earlier versions
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2010+