Zoho Sheet PERCENTILE.INC Function: Percentiles, Examples and Troubleshooting

• Introduced: The original introduction version and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
• Scope: English-language web-service documentation. Mobile and offline-client parity is outside the verified scope.
• Checked: October 14, 2026, against the official PERCENTILE.INC reference. Documentation check; not a new native test.

Zoho documents this syntax:

=PERCENTILE.INC(number_list; fraction)

Zoho’s syntax illustration uses semicolons to separate the arguments. Decimal punctuation and separators may vary with spreadsheet locale and the editing environment. Check the formula accepted by the user’s application, rather than universally substituting commas or interpreting 0.9 as 90 whole units. A percentage-formatted cell containing 90% can also be used as the fraction reference.

What “inclusive” means

The phrase refers to the permitted percentile fractions, not to an >= versus > comparison in a later IF statement. For the two endpoint fractions, the conventional inclusive percentile calculation returns the smallest or largest numeric observation. Between those endpoints, the result may fall between two recorded values. A result such as 9 is perfectly reasonable even if no data row contains 9.

Zoho confirms support for the 0-to-1 inclusive range and identifies #NUM! for out-of-range fractions or an empty numeric input. Zoho’s reference does not publish a full cross-platform availability grid or a first-supported release, so neither is asserted here.

Enter this deliberately fictional sample at A1:C11. Columns B and C must remain numeric and text, respectively.

The sorted numeric observations are 6, 8, 8, 12, 15, 18, 18, 18, 30, 50. This ordering is shown to explain the calculation, not because the function requires you to sort cells.

Example 1 — the 25th percentile

1. Put the data in A1:C11.
2. Click an unused cell such as E2.
3. Enter:

=PERCENTILE.INC(B2:B11;0.25)

Independently expected result: 9. Using the standard inclusive interpolation model, the rank is 1 + (10 − 1) × 0.25 = 3.25. The third sorted value is 8; the fourth is 12; a quarter of the interval from 8 to 12 is 1. Hence 8 + 0.25 × (12 − 8) = 9. This mathematical model is consistent with standard inclusive percentiles, but direct Zoho execution has not been observed.

Example 2 — the midpoint

=PERCENTILE.INC(B2:B11;0.5)

Expected: 16.5. The middle two observations in a ten-element list are 15 and 18, so their midpoint is 16.5. Compare =MEDIAN(B2:B11), which is expected to return the same central numeric value for this dataset. A median and an arithmetic mean are not interchangeable: the mean here is 18.3.

Example 3 — the upper quartile

=PERCENTILE.INC(B2:B11;0.75)

Expected: 18. The rank is 7.75, between the seventh and eighth values; both are 18. This also illustrates why a 75th-percentile value need not divide the rows into groups of exactly 75% and 25% when ties occur.

Example 4 — the 90th-percentile threshold

=PERCENTILE.INC(B2:B11;0.9)

Expected: 32. The interpolated rank is 9.1, between 30 and 50. Ten percent of their 20-unit difference is 2. The result is 32, even though 32 does not appear in the worksheet.

Example 5 — endpoints and cell-driven percentiles

=PERCENTILE.INC(B2:B11;0)
=PERCENTILE.INC(B2:B11;1)

Expected: 6 and 50, respectively. Put 0.9 in F2 (or format the cell as 90%) and use =PERCENTILE.INC(B2:B11;F2) to make a dashboard percentile selectable without editing the formula. Do not put 90 in F2 unless you intend an invalid 9000% percentile request.

Example 6 — exclude a row intentionally

=PERCENTILE.INC(B2:B10;0.5)

Expected: 15 for the first nine values. This is a different sample, not a different percentile method. Range boundaries should be audited whenever a new product row is added.

Create a Priority review heading in D1, then enter D2 and fill down to D11:

=IF(B2>=PERCENTILE.INC($B$2:$B$11;0.75);"Priority";"Regular")

The cutoff is 18. Independently expected priority products are Binder (18), Storage case (30), Retro game (50), Sticker pack (18), and Card box (18). Five of ten rows meet the cutoff because several products tie at 18. This is a useful warning for dashboards: percentile thresholding is not a guarantee of exactly 25% selected rows. To force a fixed number of rows, use a separately reviewed ranking-and-tie-breaking policy instead.

For a two-sided exception review, calculate lower and upper cutoffs separately in F2 and F3:

F2: =PERCENTILE.INC($B$2:$B$11;0.25)
F3: =PERCENTILE.INC($B$2:$B$11;0.75)

Then in D2 use:

=IF(B2<$F$2;"Low";IF(B2>$F$3;"High";"Middle"))

Expected groups: Low = Used DVD (6), Card sleeves (8), and Toploader (8); High = Storage case (30) and Retro game (50); Middle = the other five. Notice that these comparisons deliberately use < and >; change them only after deciding how boundary ties should be handled. Percentiles describe the supplied observations; they do not adjust for profit, seasonality, returns, or missing data quality.

• #NUM! for a percentile outside the range: Zoho documents valid fractions from 0 to 1 inclusive. 1.1, -0.1, or an accidental 90 instead of 0.9 are not valid fractions. The Zoho reference also documents #NUM! for an empty input list.
• #VALUE! or other input errors: Zoho’s general error table describes invalid data types. If a percentage arrived as literal text from a CSV import, inspect and repair it before drawing conclusions. The reference does not establish every coercion rule for numeric-looking text inside a mixed range.
• #NAME!: Check the period and spelling in PERCENTILE.INC. The legacy PERCENTILE function is a different documented name.
• #REF!: Look for deleted or moved cells, especially after inserting rows, importing tables, or copying between books.
• No number matches the percentile: Interpolation may produce a cutoff that is absent from the original observations. Do not round away a fractional threshold merely to make it match a row.
• Duplicate values: Equal observations can bunch at a cutoff. Make an explicit >/>= rule when classifying records.
• Blanks and filtered rows: Do not claim a specific hidden-row, text/boolean-coercion, or zero-versus-blank interpretation without a native Zoho test. Consider generating a separately vetted clean numeric range first.
• Too few valid observations: Small datasets can be unstable; a single extra transaction may move percentile cutoffs substantially. There is no statistical guarantee that a 90th-percentile estimate based on ten rows predicts future sales.
• Volatile imported data: When a source table changes, the thresholds update and formerly flagged products may change category. Date-stamp periodic snapshots if historical comparisons matter.

Zoho documents PERCENTILE.INC(number_list; fraction) in its English help. Microsoft Excel documents PERCENTILE.INC(array,k), including its interpolation convention and numeric-domain errors. The names and intended inclusive percentile operation align; this is not proof that Zoho and Excel match in every corner case. Excel’s displayed list separator depends on locale. Google Sheets also provides percentile functions, but confirm its exact supported names and separator settings in your target Sheet before importing formulas; this batch has not verified a per-version Google compatibility matrix.

For the minimum use MIN, for the maximum use MAX, and for the 50th-percentile central value use MEDIAN when those direct intentions are clearer. PERCENTILE.EXC uses a different interior-percentile convention and excludes the endpoint fractions 0 and 1. Legacy PERCENTILE remains documented by Zoho but Zoho recommends the newer .INC name for ongoing work. QUARTILE.INC targets numbered quartiles rather than arbitrary fractions.

Platform and version notes

Zoho’s September 2026 release notes state that its beta Windows and macOS desktop apps use Excel-native formula syntax by default for offline files. This does not establish that every Zoho web, desktop online, Android or iOS account accepts identical typed separators in all modes. The official online function page confirms current documentation, not a first-support date or universal feature history.

Is the 75th percentile the same as the top 25% of records? Not always. A threshold may coincide with duplicated values; using >= can select substantially more than one-quarter of rows.

Does PERCENTILE.INC change my original dataset? No. It returns a summary calculation; it does not sort or mutate the source range.

Can I use a percentage cell? Yes, a numeric 75% is the fraction 0.75. Verify that the cell actually contains a number and is not imported text.

Why does PERCENTILE.EXC give a different answer? The two conventions use different ranking boundaries for interpolation. For the sample above, the 75th-percentile inclusive and exclusive independent models yield 18 and 21, respectively.

• Zoho primary source: PERCENTILE.INC, checked 2026-10-12; exact function name, signature, inclusive domain and error statements.
• Zoho related documentation: PERCENTILE and PERCENTILE.EXC, checked 2026-10-12.
• Microsoft compatibility reference: PERCENTILE.INC, checked 2026-10-12; arithmetic interpolation and Excel-specific remarks.
• Release evidence: Zoho Sheet What’s New, September 2026 desktop beta syntax announcement, checked 2026-10-12.
• Validation classification: Official help researched; independent model values verified by script; native Zoho Sheet execution NOT RUN, native error cases NOT RUN.