MAX in Zoho Sheet: Syntax, Worked 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 MAX reference. Documentation and independent numeric checks; no native Zoho Sheet test.

MAX(number; [number1]; ...)

Zoho’s MAX reference allows additional arguments after the first. Square brackets describe optional arguments and are not typed. It explicitly ignores text entries and returns 0 when the input contains no numbers.

That fallback is different from an observed numeric zero. Do not use MAX alone to decide that an imported column is complete or valid. The short entry does not settle every Boolean, formula-empty-string or error-cell context.

Create a blank sheet named Orders. Enter these headers in A1:F1 and all eight records in A2:F9. Keep Amount and Units numeric; the other columns contain text.

Alternatively, download the same eight-order CSV and import it into a new blank sheet at A1, retaining its header row and comma-delimited columns. The download contains only the six input columns, not formulas or native test results. Summary results start at H, with row flags in G; neither output area overwrites the inputs in A:F.

Put the following formulas in separate cells on Orders:

Order O-103 contains the sole largest Amount, 210. O-101 and O-107 both contain 12 units. COUNTIF counts matches to the numerical maximum; it does not choose between tied records.

To identify every maximum-unit row without a lookup, put Maximum units? in G1. Enter =IF(F2=$H$3;"Maximum";"") in G2 and fill through G9. G2 and G8 show Maximum; the other six result cells are empty-looking strings. The original six input columns remain unchanged.

Copy Orders as TiedAmounts and change D9 from 80 to 210. H2 stays 210, but H5 becomes 2, reflecting O-103 and O-108. H6 remains 8. The Units column did not change, so H3/H4 and the G flags retain their original results.

A maximum alone hides this change in the distribution. If a report uses the maximum to retrieve an associated order, decide how all matching records should be handled. A first-match lookup is not proof that the maximum is unique.

Create NumericCoverage, with input values in A2:A4. Enter the text pending, missing and awaiting without quotation characters. In C2 put =MAX(A2:A4); the documented no-numbers prediction is 0. C3 =COUNT(A2:A4) is 0 for these ordinary text labels.

In C4 enter =IF(C3=0;"No numeric values";C2). Expect the text No numeric values. This guard is useful for this deliberately controlled numbers-or-status-label setup; it is not a universal type-validation rule for every imported string or logical value.

Copy the sheet as OneZero and replace A3 with the numeric value 0. C2 remains 0, but C3 becomes 1 and C4 now returns numeric 0. The same maximum value describes two different input states, which is why the count matters.

Create NegativeValues with -12,-5,-8 in A2:A4. Put =MAX(A2:A4) in C2 for -5. C3 =MAX(A2:A4;0) gives 0, because the formula has explicitly added another candidate. It has changed the question rather than “protecting” the original maximum.

Put =MAX(A2:A3;A3:A4) in C4 for -5. The overlapping reference repeats -5, but repetition does not alter an extremum. This is unlike SUM, where overlapping ranges can double-count an amount.

On VendorLiteral, put =MAX(12;-19;10;23) in A2 for 23, reproducing the complete literal example in Zoho’s entry. Its separate embedded-range examples do not expose their full input values in the article text, so this guide does not invent those cells.

A high amount is not automatically erroneous. MAX supplies a numerical comparison; it does not decide whether an order is valid, comparable or in the right reporting period. Keep the intended records and units consistent.

The input and output areas here are separate, and only complete numeric ranges or the explicitly described status labels are used. Native Boolean/error coercion, numeric-text imports, locale conversion and workbook round trips remain unverified. A generic error list is not a detailed test matrix for those cases.

MIN finds the other extremum. LARGE selects an ordered position and retains repeated observations. MAXIFS adds conditions under its own shape and type rules; an unconditional MAX does not filter records automatically.

English examples use semicolons between arguments and a colon within a range. Check the target workbook’s notation before copying formulas across spreadsheet products.