Home › Functions › Statistical › =PERCENTRANK.INC()
Statistical Excel 2010 ◉ 18 views

=PERCENTRANK.INC()

Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=PERCENTRANK.INC(array,x,[significance])
Hover argument names in the table for details.
Output typeNumber
Popularity25 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =PERCENTRANK.INC() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download PERCENTRANK.INC.xlsx ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
array Array Required The array or range of data with numeric values that defines relative standing.
x Number Required The value for which you want to know the rank.
significance Number Optional A value that identifies the number of significant digits for the returned percentage value. If omitted, PERCENTRANK.INC uses three digits (0.xxx).

▣ Examples

▦ Data
CellValue
A2 13
A3 12
A4 11
A5 8
A6 4
A7 3
A8 2
A9 1
A10 1
A11 1
A12 13
A13 12
A14 11
A15 8
A16 4
A17 3
A18 2
A19 1
A20 1
A21 1
Percent rank of 2 in the range A2:A11 (0.333, because 3 values in the set are smaller than 2, and 6 are larger than 2; 3/(3+6)=0.333). =PERCENTRANK.INC(A2:A11,2)
Result: 0.333
Percent rank of 4 in the range A2:A11. =PERCENTRANK.INC(A2:A11,4)
Result: 0.555
Percent rank of 8 in the range A2:A11. =PERCENTRANK.INC(A2:A11,8)
Result: 0.666
Percent rank of 5 in the range A2:A11 (0.583, one-quarter of the way between the PERCENTRANK.INC of 4 and the PERCENTRANK.INC of 8). =PERCENTRANK.INC(A2:A11,5)
Result: 0.583

§ Remarks

  • If array is empty, PERCENTRANK.INC returns the #NUM! error value.
  • If significance < 1, PERCENTRANK.INC returns the #NUM! error value.
  • If x does not match one of the values in array, PERCENTRANK.INC interpolates to return the correct percentage rank.

✦ Tips

  • If x does not match one of the values in array, PERCENTRANK.INC interpolates to return the correct percentage rank.

⚠ Common Errors

#NUM! If array is empty, PERCENTRANK.INC returns the #NUM! error value. If significance < 1, PERCENTRANK.INC returns the #NUM! error value.
Fix: اطمینان حاصل کنید array حداقل یک مقدار عددی دارد و برای significance عددی بزرگ‌تر یا مساوی ۱ وارد کنید.

⇄ Related Functions

=TEXT() The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. =PERCENTILE.INC() PERCENTILE.INC returns the k-th percentile of values in a range, where k is in the range 0..1, inclusive. You can use this function to establish a threshold of acceptance. =PERCENTRANK.EXC() Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set. =RANK.EQ() Returns the rank of a number in a list of numbers. Its size is relative to other values in the list; if more than one value has the same rank, the top rank of that set of values is returned. If you were to sort the list, the rank of the number would be its position.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.