PERCENTRANK.EXC Function (LibreOffice Calc)

• Introduced: LibreOffice 4.3.
• Availability: Supported in LibreOffice 26.8.1.1, verified against its function registry. This identifies a supported release, not a final working version.
• Scope: Desktop Calc, using the English function name. Availability in other spreadsheet applications is separate.
• Checked: 2026-10-14 — function reference; versioned support. Documentation/source check; not a new native test. Existing example-specific test claims below retain their stated scope.

For a distinct sorted sample of n observations, an exact match at one-based position i uses i/(n+1). The smallest and largest observations therefore occupy interior plotting positions for an ordinary multi-value sample. “Exclusive” describes that rank convention; it does not mean the input must exclude the observed endpoints or that this method is inherently more rigorous than the inclusive method. Official Help.

Choose the rank convention required by your analysis or reporting specification. PERCENTRANK.INC uses a different denominator and can give different ranks from the same observations.

=PERCENTRANK.EXC(Data; Value [; Significance])

Data and Value are required. Significance is optional and defaults to 3 significant digits, not three decimal places. The evaluator floors the supplied significance and rejects values below 1. It sorts the numeric sample, then rejects a Value below the sample minimum or above its maximum. Release evaluator.

The dispatcher selects the exclusive branch. Its sorting and precision machinery is shared with the inclusive function, but the rank formula differs. Cell number formatting changes only the displayed appearance; Significance changes the returned numeric result.

Enter these samples. A has distinct values; B includes three tied 20s.

These are independent mathematical references to the pinned source contract, not newly captured application outputs.

The unrounded rank of 25 in A is 2.5/8=0.3125. Default significant-digit rounding makes it 0.313. =PERCENTRANK.EXC(A2:A8;25;4) instead returns 0.3125. Value 5 or 75 lies outside this sample and is rejected.

An exact tie uses its first matching sorted position rather than the average of all tied positions. In B, the first 20 is at position 2, so its rank is 2/8=0.25. Value 30 lies between the final 20 at position 4 and 40 at position 5, giving 4.5/8=0.5625 before rounding. Exact tie and interpolation logic.

This can produce a jump immediately above a run of ties. The result is not simply the fraction of observations at or below Value. Keep the rank convention explicit when ranking rounded measurements or discrete scores.

The shared evaluator returns 1 when a sample contains a single numeric value matching Value, including this exclusive entry. For example, with A2=10, =PERCENTRANK.EXC(A2:A2;10) returns 1. Do not extend the ordinary i/(n+1) formula to that separately handled singleton case.

Rounding can also create 1. For a sample containing the integers 1 through 20 in C2:C21, =PERCENTRANK.EXC(C2:C21;20;1) rounds 20/21 to 1. Therefore a blanket claim that this function can never return 0 or 1 is not a safe description of the actual release contract.

Format 0.25 as a percentage to display 25%; do not multiply by 100 and also apply percentage formatting. Choose enough significant digits before comparing ranks with a cutoff. Retain the original observations so a reported percentile position can be traced to its reference group.

Prepare a complete numeric analysis range. A conditional formula that inserts FALSE or zero for excluded observations can change the ranked sample. AGGREGATE returning a single selected order statistic is not a substitute for the complete dataset. Do not suppress out-of-range or empty-sample errors as a plausible zero rank.

The cited 26.8.1.1 evaluator, exclusive dispatcher and function-specific Help were checked against retained sources. All values above were computed independently. No new LibreOffice native run, locale test or import behavior is claimed for this article.