Contact
12 programs
Explore the site

PERCENTRANK Function in Apple Numbers: Syntax, Examples and Troubleshooting

Statistical Intermediate Apple Numbers

Step-by-step Apple Numbers PERCENTRANK formulas, reproducible examples, limits, locales and troubleshooting.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: Enter =PERCENTRANK(B2:J2,10) when B2:J2 contains Apple’s example observations 5, 6, 9, 3, 7, 11, 8, 2, 14. Apple’s documentation says the result is approximately 0.813: that is about 81.3% of the way up the sample’s ranked scale, not a 0.813% probability. PERCENTRANK answers where a particular observation sits in a reference set; it is not PERCENTILE, which answers the inverse question of what observation marks a given percentile.

Availability and version history

  • Introduced: Documented in Apple’s Formulas and Functions Help 15.4; the original introduction release is not established.
  • Availability: Currently documented for Numbers in that help version; it is not a final supported-version endpoint.
  • Scope: Shared iWork function help; individual client and older-release availability is not established by this check.
  • Checked: October 14, 2026, against the official PERCENTRANK reference. Documentation and independent arithmetic checks; no native Numbers test.

What PERCENTRANK does (and does not do)

A percentile rank describes a value’s relative position among the observations. If scores or delivery times use comparable units and a consistent measurement period, percentile rank lets you benchmark one score against all recorded scores. Apple documents the function for a single value and a value-set whose members all share one type: number, date/time, or duration. It does not permit mixing these types in one supplied collection.

The return is a fractional rank such as 0.813; show it as a percentage only if the cell’s display format multiplies by 100, yielding about 81.3%. A high percentile does not automatically mean good performance: for delivery delays or costs, lower may be better. It is also not a probability forecast and must not be described as the chance of a future event.

Exact Apple syntax, order, types and defaults

=PERCENTRANK(value-set, value, significance)
Position Argument Required? Type, restriction and purpose Default
1 value-set Yes Collection of one compatible type: all numbers, all date/times, or all durations. The set defines the ranking context. None
2 value Yes One number, date/time, or duration to rank; it must be the same type as the collection. None
3 significance No Number specifying digits to the right of the decimal point in the result; Apple requires significance >= 1. Use an integer digit count for readable precision. 3

In Apple’s published English syntax, optionality is indicated through the syntax-description conventions; the displayed textual signature itself includes the third name. significance=3 means a result on the 0.xxx scale, not a percent sign inserted into the output. Apple’s help specifies a number >=1, but does not establish how non-integer significance is coerced; do not rely on fractional precision counts without native testing. See the troubleshooting section for limits of the documented behavior.

Locale, table names and references

Use commas in English-locale formulas: =PERCENTRANK(B2:J2,10,3). In settings that use a comma as the decimal separator, Apple instructs you to separate function arguments with semicolons, for example =PERCENTRANK(B2:J2;10;3). Do not use semicolons universally; follow the formula editor’s regional syntax.

Apple Numbers has tables on sheets. A range in the current table may appear as B2:J2. When referencing a table named Scores from a different table, the correct Numbers style is Scores::B2:J2 when qualification is needed; when referencing a different sheet, Apple documents the Sheet Name::Table Name::cell/range pattern. Select cells with the formula editor to resolve names and handle absolute-reference anchors; don’t paste Excel’s Sheet1!B2:J2 reference form into a Numbers tutorial.

Reproduce Apple’s published scores worksheet

  1. Create a Numbers table called Scores with at least eleven columns (A:K) and six rows. Set A1 to Metric. Put the following numeric values in B2:J2, in the listed sequence—not sorted or as text. These inputs reproduce Apple’s published example.
  2. Set A3 to Rank of 10 and enter =PERCENTRANK(B2:J2,10) in an empty results cell such as K3. You may instead place the formula in a second table and use the qualified Scores::B2:J2 source range.
  3. Format the result as a normal Number for approximate 0.813, or as Percentage for approximately 81.3% (display precision may depend on the selected cell format). Percentage formatting changes the display; it does not change the stored fractional rank.
Cell B2 C2 D2 E2 F2 G2 H2 I2 J2
Score 5 6 9 3 7 11 8 2 14

Reproducible comparisons

Formula in an empty cell in the same table Expected decimal rank Interpretation
=PERCENTRANK(B2:J2,10) approximately 0.813 Apple’s published example; the true mathematical interpolation is 0.8125.
=PERCENTRANK(B2:J2,9) approximately 0.750 Score 9 sits at sorted position 7 of 9 (zero-based rank 6/8).
=PERCENTRANK(B2:J2,11) approximately 0.875 Score 11 sits at sorted position 8 of 9 (zero-based rank 7/8).
=PERCENTRANK(B2:J2,10,4) mathematically 0.8125 Four-decimal expected result from interpolation and Apple’s precision argument.
=PERCENTRANK(B2:J2,QUARTILE(B2:J2,2)) approximately 0.500 Nest the documented median quartile, whose value is 7 for this set.

How to check: Sort these nine numbers mentally or in a separate scratch table to get 2,3,5,6,7,8,9,11,14. The value 10 lies halfway between 9 and 11. Their rank fractions are 6/8=0.75 and 7/8=0.875, so interpolation gives 0.75+(10−9)/(11−9)×(0.875−0.75)=0.8125. With three digits the Apple published approximation is 0.813. This calculation checks the example; it does not establish an interpolation rule for every edge case.

Advanced practical uses

Compare a benchmark without changing the reference range

Enter 10 in A5 and 9 in A6. In B5, enter this formula, then fill it down to B6:

=PERCENTRANK($B$2:$J$2,A5)

Both target values are compared with the same unchanged reference set in B2:J2. Apple explains $ absolute row/column components for copied formulas; use the Numbers formula editor to confirm the reference remains anchored. For A5=10, the expected result is Apple’s 0.813; for A6=9, expected 0.750 if filled correctly.

Relate percent rank to quartiles

Apple’s QUARTILE documentation gives QUARTILE(B2:J2,1)=5, QUARTILE(B2:J2,2)=7 and QUARTILE(B2:J2,3)=9 for this set. A quartile returns a data value at a specified quarter point, while PERCENTRANK returns a relative fraction for a specified value. For unique observations in this nine-value example, 7 is the median and has relative standing 0.5.

Dates and durations—same-type only

Apple expressly permits homogeneous date/time and duration collections as well as numbers. For a delivery-time table, provide durations as actual duration-formatted values, not the text string "35 min"; compare with a duration value of the same type. For a date-based ranking, compare a date/time against a homogeneous date/time column. These are documented argument types; keep date/time and duration values separate from ordinary numeric scores.

Troubleshooting and limits

Symptom or question Practical check and evidence
A result of 0.813 is mistaken for 0.813% Treat the result as a fraction: 0.813 × 100 ≈ 81.3%. Choose a suitable percentage display format; avoid multiplying by 100 and applying percentage formatting.
Formula parser refuses commas Verify local number formatting. Apple’s overview prescribes semicolon argument separators when the decimal separator is a comma.
Collection contains a mixture of number, date, and duration Separate the types: Apple requires a homogeneous value-set and matching value type.
significance is omitted Apple documents a default of 3 digits; use an explicit positive integer such as 4 when reviewing precision.
significance=0 or negative Outside Apple’s documented >=1 bound; correct the input.
Values are numeric-looking text Confirm that values have a genuine Numbers numeric/date/duration type; mixed typed observations violate Apple’s function contract.
An out-of-range target or tied score behaves unexpectedly Apple’s individual help does not fully specify ties, extrapolation or an exact error-code matrix. Use documented in-range distinct observations for a reproducible comparison and test those edge cases in your Numbers version before relying on them.
Formula pasted from Excel uses ! or unrecognized sheet/table Use Numbers’ table :: references, or select range tokens in the formula editor.
Results change when new observations are added A percentile rank is relative to its current value-set. Keep the comparison sample fixed for fair benchmarks. Mathematical interpretation, not a claim about recalculation timing.