Home › Functions › Statistical › =PERCENTRANK.EXC()
Statistical Excel 2010 ◉ 2 views

=PERCENTRANK.EXC()

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

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

⬇ Download Sample Workbook

A dedicated .xlsx for =PERCENTRANK.EXC() 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.EXC.xlsx — Coming soon ~ 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.EXC uses three digits (0.xxx).

▣ Examples

رتبه مقدار 7 در آرایه موجود در A2:A10 را برمی‌گرداند. =PERCENTRANK.EXC(A2:A10, 7)
رتبه مقدار 5.43 در همان آرایه را برمی‌گرداند. =PERCENTRANK.EXC(A2:A10,5.43)
رتبه مقدار 5.43 در همان آرایه را با نمایش تنها 1 رقم معنادار در نتیجه برمی‌گرداند (پیش‌فرض 3 رقم است). =PERCENTRANK.EXC(A2:A10,5.43,1)

✦ Tips

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

⚠ Common Errors

#NUM! If array is empty, PERCENTRANK.EXC returns the #NUM! error value. If significance < 1, PERCENTRANK.EXC returns the #NUM! error value.
Fix: آرایه را پر کنید و برای significance عدد 1 یا بیشتر وارد کنید.

⇄ Related Functions

=PERCENTILE.EXC() The PERCENTILE.EXC function returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. =PERCENTRANK.INC() Returns the rank of a value in a data set as a percentage (0..1, inclusive) 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.