Zoho Sheet PERCENTRANK.INC: Syntax, Percent Ranks and Examples

• 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 PERCENTRANK.INC reference. Documentation check; not a new native test.

PERCENTRANK.INC returns a fraction describing the relative standing of a numeric observation within a range. Zoho explicitly describes the result as within 0..1 inclusive; the first observation can be associated with 0, the last with 1, and observations between them fall along that scale. This is useful for comparing sales volumes from different product lines, setting descriptive service-level benchmarks, or answering questions such as “Where does this week’s order count rank relative to past weeks?”

For distinct sorted observations, a transparent conventional inclusive model assigns zero to the smallest number, one to the largest, and divides positions between them. For n distinct values, the model for an observation in 1-based sorted position i is (i−1)/(n−1). The official Zoho help confirms the convention and syntax, but does not explicitly document every interpolation, duplicate-value or error detail. Mathematical demonstrations below should therefore not be mistaken for verified native Zoho behavior.

=PERCENTRANK.INC(number_list; number; [significance])

• number_list (required): range/array of numeric observations, for example B2:B10. The Zoho help uses A2:A6 as its illustrative range.
• number (required): the numeric value to locate, such as B8, 70 or a calculation result. It can be a reference to a cell outside the data range, provided it is numeric and meaningful.
• significance (optional): the number of digits used in the returned result. Zoho states that the default displays three digits (0.xxx) and explicitly documents #NUM! when significance is less than 1. Use a positive integer, such as 4, if you need to compare finer calculated fractions. Do not confuse significance with a percentage parameter such as 0.75.

The semicolon-separated syntax is transcribed from Zoho’s help, not silently adapted from Excel. In particular, the number_list parameter comes first, unlike the RANK(number;number_list;...) argument order.

Create an empty worksheet and type the following data into A1:B10, keeping the nine values in column B numeric (not text). The rows are deliberately sorted for transparent manual inspection; the rank function should operate on numeric input ranges, not require the visible sheet to be manually sorted.

The sample contains nine distinct observations, so ties, missing cells and text-value coercion are intentionally absent from the core examples. The value in B2 is the lowest observation, while B10 is the highest. Do not include the header in B2:B10. Percent ranks are unitless fractions from zero toward one; percent formatting turns a fraction like 0.75 into 75%, without changing the underlying number.

What a percentage rank measures

A percentage rank asks where a known numeric value stands among observations. It is the reverse kind of question from PERCENTILE.INC(range;0.75), which asks which numeric value corresponds to the 75th-percentile cutoff. Neither is the same as the ordinary ordinal rank given by RANK, and neither by itself estimates customer demand or guarantees inventory decisions. Report which convention you used, whether observations repeat, and how small the sample is; a small sample’s apparent precision can be misleading.

1. Paste the sample dataset into A1:B10. Click an empty cell, such as D2.
2. Type =PERCENTRANK.INC($B$2:$B$10;B2) and record the model expectation 0 for the minimum value 10.
3. Copy the formula downward alongside values 20 through 90; the $ symbols keep the comparison range anchored while the target moves from B2 to B10.
4. Format the output column as percent if you want people to read 0.75 as 75%. This affects presentation rather than the number.
5. Check a literal target with =PERCENTRANK.INC($B$2:$B$10;70;4); the modeled result is 0.75 with additional significance specified.

To understand the last row, the position of 30 is (3−1)/8=0.25; the position of 40 is (4−1)/8=0.375. Thirty-five is halfway between those values, giving 0.25+0.5×(0.375−0.25)=0.3125 by standard linear interpolation. The formula’s actual Zoho output for a value not present in the list has not been verified. Its help gives sample outputs but no explicit interpolation algorithm.

Suppose the weekly-units column contains the product’s sales during a selected period. In C1 label a new column Comparison band, and in C2 enter:

=IF(PERCENTRANK.INC($B$2:$B$10;B2)>=0.75;"Upper quarter";"Other")

Copy C2 through C10. With the conventional model, B8=70, B9=80 and B10=90 will have percent ranks at or above 0.75 and be labeled Upper quarter; the other six will be Other. This demonstrates relative targeting without manually sorting the original sheet. Consider leaving the rank in another column for auditing rather than hiding a complex calculation inside IF.

For a dynamic benchmark from recent weeks, place a target volume in E2, then use =PERCENTRANK.INC($B$2:$B$10;E2;4) in F2. Document the date range of the comparison sample, the inclusion convention and the fact that a rank is not a predicted probability. If an out-of-range future value is supplied, the resulting error/handling is an important native test case, not something to guess from Excel.

#NUM! and precision: Zoho explicitly lists #NUM! for significance < 1. =PERCENTRANK.INC(B2:B10;50;0) is therefore an intentional invalid-input test example, not an executable test we performed. Its generic error table also lists #N/A!, #NAME!, #VALUE!, and #REF!, but does not provide a complete argument-specific mapping for empty arrays or out-of-range target values. For a reproducible diagnosis, first test the literal 50 against the numeric nine-row dataset, then change one input at a time.

Repeated values and blanks: This introductory dataset has unique numbers. A repeat should normally remain an observation; removing it arbitrarily changes sample size. However, Zoho’s exact tie ranking, text-to-number coercion and treatment of empty/filtered rows are not established by the retrieved function page. Re-test with duplicates, negatives, blank cells and numeric-looking text in a real Zoho workbook before relying on a definitive edge-case rule.

Out-of-range targets: A target below 10 or above 90 is outside the sample. Do not extrapolate mathematically as if it were an observed percent rank. Zoho’s help does not establish precisely whether each such case returns #N/A! or another result. Record the actual native outcomes for your workbook.

Display versus precision: Setting a cell’s number format to 0.00% is not the same as changing the optional significance argument. Formatting affects visibility while significance controls the function-reported precision according to the vendor. Because the documentation says “digits” rather than specifying every rounding/truncation case, test a result such as 0.3125 directly if precision matters operationally.

Microsoft Excel documents PERCENTRANK.INC(array,x,[significance]), including interpolation for values not exactly in the array and the default three-digit precision. Google Sheets documents PERCENTRANK.INC(data,value,[significant_digits]), also describing estimation when the target is not directly present. English examples on those platforms normally use commas; Zoho’s documentation uses semicolons. Treat the same function name as a compatibility hypothesis, not proof of identical treatment of ties, malformed data, out-of-range results or desktop imports. If you need the value at a fraction such as 0.75, choose PERCENTILE.INC, not this function. For simple ordinal placement, consider RANK/RANK.EQ instead. If you specifically need a fraction excluding both endpoints, research PERCENTRANK.EXC—but see its documentation warning before relying on boundary values.

The named function is present in Zoho’s official statistical function catalogue and its individual help reference was checked October 12, 2026. These sources do not establish a trustworthy first-supported release, complete web/mobile/desktop support matrix, historical compatibility timeline or exact availability for every account. The documented formula uses semicolons as separators; Excel and English-language Google Sheets help usually show commas. Workbook locale, formula-import mode or a particular editor may change the separator presented to the user. Do not invent a device-specific guarantee.

Validation disclosure: Official help was inspected directly. Every number called model expected below was independently calculated with ordinary arithmetic on the provided dataset. No formula was executed in a native Zoho Sheet workbook. These are independent model calculations, not verified native results.

• Official Zoho PERCENTRANK.INC reference — consulted October 12, 2026.

• Official Zoho Sheet function catalogue — function reference index.
• Microsoft Excel PERCENTRANK.INC help and PERCENTRANK.EXC help — compatibility comparison, checked October 12, 2026.
• Google Sheets PERCENTRANK.INC and PERCENTRANK.EXC — official Google documentation, checked October 12, 2026.
• Related guides: PERCENTILE.INC, PERCENTILE.EXC, MEDIAN, RANK.