Apple Numbers MAXA: Maximum Values with Text and Boolean Inputs
Use MAXA in Numbers with reproducible mixed-type examples, explicit text/boolean conversions, a MAX comparison and a numeric summary of logical flags.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: If A2:C2 contains −3, −8 and the text pending, =MAXA(A2:C2) returns 0. In a referenced cell, MAXA assigns text a value of zero. It can therefore return a value that was never entered as a numeric measurement.
Availability and version history
- Introduced: The original release and introduction date are not established by the checked references.
- Availability: Currently documented in Apple’s Functions Help 15.4 documentation edition. No final supported-version endpoint is established.
- Scope: Shared iWork reference; exact historical availability in individual Mac, iPad, iPhone and iCloud builds remains unverified.
- Checked: October 14, 2026, against the official MAXA reference. Examples checked by independent typed-value and selection models; no native Numbers test.
Syntax and conversion rules
=MAXA(value, value…)
The first value or collection is required; additional ones are optional. Apple’s reference assigns referenced text and FALSE to 0, and TRUE to 1. Text may appear in a referenced cell, but a direct string argument is outside the documented input rule.
Date/time or duration inputs must be homogeneous: do not mix either type with ordinary numbers, text or booleans. The examples below deliberately use numeric, text and logical inputs without date or duration values.
MAX has a different referenced-cell rule: it ignores text and booleans when choosing the maximum. The extra A therefore changes the calculation, not just its spelling.
Practice table: make every converted candidate visible
Create a Numbers table named MaxCases, with six columns A:F and eight rows, including one header row. Use Input 1, Input 2, Input 3, MAXA, MAX and Explanation as headers. Enter A2:C8 as follows. For TRUE and FALSE use =TRUE() and =FALSE() so the type is explicit; enter the words as plain text without quotes.
| Row | A | B | C | Expected D: MAXA | Expected E: MAX |
|---|---|---|---|---|---|
| 2 | -3 | -8 | pending | 0 | -3 |
| 3 | -3 | -8 | FALSE | 0 | -3 |
| 4 | -3 | -8 | TRUE | 1 | -3 |
| 5 | 0.2 | 0.4 | TRUE | 1 | 0.4 |
| 6 | -3 | -8 | -1 | -1 | -1 |
| 7 | 3 | 8 | pending | 8 | 8 |
| 8 | -1 | -10 | hello | 0 | -1 |
Put =MAXA(A2:C2) in D2 and =MAX(A2:C2) in E2. Fill D2:E2 through row 8. Use F for your own explanation of which candidate wins; do not type an explanation into the numeric or logical source cells.
Row 2 compares −3, −8 and the converted zero. Row 4 compares −3, −8 and the converted one. Row 5 shows that a boolean can exceed ordinary positive fractions. Row 6 confirms that MAXA does not automatically impose a lower bound of zero when all supplied candidates are negative numbers.
Row 8 reproduces Apple’s text-cell example. Its result is zero because hello is converted for this calculation, not because MAXA located an actually measured zero.
Direct numeric and boolean controls
Create a separate two-column table named MaxControls, with five rows. Enter these formulas in B2:B5:
| Cell | Formula | Expected result |
|---|---|---|
| B2 | =MAXA(1,2,3,4) |
4 |
| B3 | =MAXA(-5,TRUE) |
1 |
| B4 | =MAXA(-5,FALSE) |
0 |
| B5 | =MAXA(0.2,0.4) |
0.4 |
The first is Apple’s numeric example. The others isolate the boolean mapping and a numeric-only case. Do not replace a referenced text cell with a quoted direct string and assume the call remains valid; Apple explicitly distinguishes those input forms.
Advanced: a numeric flag for any checked condition
Create a separate table named CheckFlags, with six columns and five rows. Put Session, Check A, Check B, Check C, Numeric any and Logical any in A1:F1. Enter the labels S1–S4 in A2:A5, and use TRUE()/FALSE() formulas for B2:D5:
| Row | B | C | D | Expected E | Expected F |
|---|---|---|---|---|---|
| 2 | TRUE | FALSE | TRUE | 1 | TRUE |
| 3 | FALSE | FALSE | FALSE | 0 | FALSE |
| 4 | TRUE | TRUE | TRUE | 1 | TRUE |
| 5 | FALSE | TRUE | FALSE | 1 | TRUE |
Enter =MAXA(B2:D2) in E2 and =OR(B2,C2,D2) in F2. Fill E2:F2 through row 5. For these known booleans, MAXA gives a numeric 1 when any flag is true and 0 otherwise. OR gives a logical result for the same question.
The equivalence depends on the input policy. If a numeric 7 or text note is allowed into the flag cells, MAXA’s ordinary conversion and maximum rules still apply; it has not become a general validator of boolean data. Prefer OR when the desired output is explicitly logical.
Errors and practical interpretation
Text placeholders can distort a maximum of negative measurements, while TRUE can distort a maximum of fractions below one. Choose the function according to whether those conversions are intentional. Changing a number format does not necessarily change the stored type of an imported value.
The short reference does not fully define empty ranges, formula-produced empty text, errors or every native error token. Those cases are distinct from the populated fixtures here. No exact error label is asserted for a forbidden direct string or a mixed date/number input.
Keep output cells outside their input ranges. Use the Numbers reference editor when selecting data from another table, and follow the document’s argument separators.
MINA uses the same documented text/boolean mapping to choose the minimum. MAXIFS selects candidates by explicit conditions; its matching rules are a separate question from MAXA’s conversions.