PERCENTILE in Collabora Office: Percentile Cutoffs, Included Data and Selected Rows

• Introduced: original Collabora release and launch date are not established by the reviewed sources.
• Availability: currently documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployments are not inferred from this desktop-help release.
• Checked: October 14, 2026. Function-specific documentation and independent calculations; no native Collabora execution.

=PERCENTILE(data;alpha)

Both arguments are required. Alpha is a fraction between 0 and 1, so 0.25 and 25% represent the same requested first-quartile point. Use English function names and semicolon separators for these examples.

The dedicated reference explicitly ignores text and empty cells within a data range. A numeric zero is an observation and must not be removed merely because it looks uninformative.

For interior numeric calculations, the independent inclusive-position model used below is 1+(n-1)×alpha in sorted data, with linear interpolation between adjacent positions. The compact source names the percentile scale but does not print that complete equation; the worked figures are transparent mathematical expectations, not native captures.

Enter 4,9,15,25,45 in A2:A6:

For five values, the model positions are 1,2,3,4,5. The middle output also matches the source’s explicit median relationship. The arithmetic mean is 19.6, which answers a different question from the median 15.

=PERCENTILE(A2:A6;0.9)

Independent expected result: 37. The position is 4.6, so move 60% from 25 toward 45: 25+0.6×20=37.

No input equals 37. A percentile cutoff is not necessarily an instruction to return an existing record. LARGE describes a separately defined order-statistic selection.

Add text Pending in A7 and leave A8 empty. The documented range exclusion keeps the median and primary upper-quartile model at 15 and 25.

Replace Pending with numeric 0. Sorted observations become 0,4,9,15,25,45. The new median is 12, midway between 9 and 15. The upper-quartile model uses position 4.75, giving 22.5 between 15 and 25.

That change reflects a measured numeric observation entering the dataset. It is different from merely changing an explanatory label.

Restore the original five values. Their 75th-percentile cutoff is 25. A strict comparison selects only 45; an inclusive comparison selects 25 and 45:

=COUNTIF(A2:A6;">"&PERCENTILE(A2:A6;0.75))
=COUNTIF(A2:A6;">="&PERCENTILE(A2:A6;0.75))

Expected counts are 1 and 2, or 20% and 40% of five observations. Discrete rows and ties prevent a percentile label from guaranteeing an exact selection percentage.

Transform every original value with 2×value+3, producing 11,21,33,53,93. The independent 90th-percentile result is 77, matching 2×37+3. The median becomes 33.

A positive affine conversion preserves the ordered positions and transforms their interpolated values consistently. A nonlinear transformation needs its own check.

PERCENTILE remains documented in 26.04. PERCENTILE.INC has a separate current section; shared purposes do not establish every type/error alias behavior or retirement.

The range-ignore note does not settle Boolean cells, direct strings, formula-empty values, mixed errors, empty datasets or exact invalid-alpha error codes. Those remain unverified. Preserve full calculation precision and label the selected percentile convention beside any threshold used for decisions.

• Collabora Office 26.04: PERCENTILE.
• Editorial testing standards.

Complete function-specific documentation reviewed. Worked outputs are independent mathematical models or explicitly documented rules, not application screenshots or native test results. Precision, type and error boundaries retain their stated limits.