Zoho Sheet MAXA: Text, Logical Values and Negative-Number Traps

• Introduced: The original introduction release and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no retirement endpoint is established.
• Scope: English-language web-service documentation. Exact mobile and offline-client parity is not established here.
• Checked: October 14, 2026, against the official MAXA reference. Documentation and independent typed-value/selection calculations; no native Zoho Sheet test.

=MAXA(value; [value1]; ...)

The first value is required, with additional values optional. A range can supply several entries. Zoho’s reference maps text to 0, logical TRUE to 1, and logical FALSE to 0. MAXA selects the largest value after that evaluation.

This makes MAXA different from a request to find the largest numeric observation while discarding labels. Use it only when these conversions match the question. Quoted text in a formula is different from a Boolean expression; the examples use TRUE() and FALSE() when a genuine logical result is intended.

Create MixedMaximum. Put Input in A1 and Manual numeric mapping in B1. Enter the following cells; the text pending has no enclosing quote characters in A5.

Column B is a manually entered reconstruction of the documented type rule, not a formula that guesses types from how cells look. Put these formulas in D2:D7:

D3 changes because pending contributes zero; no sensor or transaction recorded a zero there. D4 adds a logical TRUE, which contributes one. D5 partitions the same six entries across two arguments. D6 verifies the maximum of the explicitly mapped numbers.

The official MAX entry says it ignores text, supporting the D7 comparison on the three numbers and the text label. That comparison deliberately excludes the Boolean rows rather than assuming every MAX Boolean rule from MAXA.

Keep A:D intact. Enter these formulas in F2:F5:

F5 is the complete literal example printed in Zoho’s MAXA article. Its largest number, 23, exceeds both the converted text zero and logical zero. A mixed-type example can therefore hide the effect of conversion when a larger positive number is already present.

Create CompletedReadings separately. Put −8,−3,−5,−1 in A2:A5, with Reading in A1. Enter =MAXA(A2:A5) in C2 and =MAX(A2:A5) in C3. Both targets are −1.

The original label-containing range returned zero under MAXA. Completing it with a real negative measurement makes the result smaller, even though the data is now more complete. This is a conversion effect, not evidence that conditions deteriorated. Preserve the original status information when resolving incomplete measurements.

For a positive comparison on this new sheet, put 4,9,pending in E2:E4. In G2 enter =MAXA(E2:E4) and in G3 enter =MAX(E2:E4). Both give 9. Agreement here does not prove the two functions treat text identically; the converted zero simply cannot exceed 9.

Create Flags with =FALSE(), =TRUE() and =FALSE() in A2:A4. In C2 enter =MAXA(A2:A4); expect numeric 1. In C3 enter =MAXA(A2;A4); expect numeric 0.

These outputs use the documented Boolean mapping. They are numeric extrema, not a general claim that MAXA is interchangeable with a logical function in every formula. The TRUE and FALSE references establish the Boolean-producing formulas used here.

The short MAXA entry does not separately specify truly empty cells, formula-produced empty strings, all error cases or the treatment of every imported numeric-looking string. A blank-looking display is not enough to classify a cell. These fixtures contain explicit numbers, ordinary text and generated Boolean values, without relying on unknown empty/error behavior.

Use MAX for the documented text-ignoring comparison, MINA for the smallest evaluated value, and MAXIFS when record conditions define which numeric candidates should be considered. English Zoho examples use semicolons between arguments; select actual ranges when adapting them to another sheet.