MAX Function in Apple Numbers: Syntax, Examples, and Troubleshooting

Apple documents MAX(value, value…): supply at least one value, meaning a value or collection/range. value… indicates any number of optional further values or collections.

=MAX(value, value…)

=MAX(4,9,7) has expected result 9; =MAX(B2:B8) searches a range. Apple’s reference allows numbers, date/time values or duration values, but the latter two cannot be mixed with other value types. Text and booleans in referenced cells are ignored, and they are not acceptable as direct arguments. A column formatted to look numeric does not guarantee its imported contents are numeric.

Source: Apple MAX.

1. Create a new spreadsheet and add or rename a table Orders. Make the first row its header row.
2. Add three columns with the headers Order ID, Amount (CAD), and Region in A1, B1 and C1.
3. Enter the following seven records in A2:C8. Type pending as plain text in B7. Leave B8 genuinely empty (do not type the words “empty” or 0).
4. Set B2:B6 to Number or Currency so these five entries are numeric cells. Place every result formula in a separate result cell, for example E2, in the same Orders table.

Why this matters: B2:B6 contains exactly five numbers (120, 75, 90, 115, 35). B7 is text and B8 is blank; these are deliberately different cases. A2:A8 contains seven nonempty text order IDs. The worked answers below are independent calculations for this particular table, not screenshots or claims of a Numbers execution.

1. In the separate E2 result cell, enter:

=MAX(B2:B8)

2. Confirm the range is B2 through B8 (not A or C).

Expected result: 120. Comparing 120, 75, 90, 115 and 35, the largest is 120, located at B2. The text pending (B7) and blank B8 do not add numeric amounts. Currency formatting may display $120.00; that is formatting, not another result.

=MAX(B3:B6)
=MAX(120,75,90,115,35)

Expected results: 115 and 120. The first excludes B2, the highest order. The second accepts literal numeric arguments and includes it. Range selection is crucial to peak tracking.

To find a region-specific peak, Apple documents MAXIFS(range, criteria-range, criteria, ...). Unlike MAX, this function checks corresponding entries across two aligned ranges. Use only the five recorded numeric rows for an unambiguous example.

=MAXIFS(B2:B6,C2:C6,"West")

Expected result: 115. Of the West entries (rows 3 and 5), 115 exceeds 75. The candidate numeric range B2:B6 must appear before the condition range C2:C6; both contain five rows. A criterion with no matching records returns 0 according to Apple, so treat that as a missing-match diagnostic, not an observed zero-valued order.

A useful nonconditional spread measure is:

=MAX(B2:B6)-MIN(B2:B6)

Expected result: 85, because 120 minus 35 equals 85. This is the sample’s full numeric range, not its median or standard deviation.

Source: Apple MAXIFS.

• The maximum seems too small: Check whether the range starts at B3; B2 contains 120 and excluding it changes the result to 115.
• Values look numeric but do not affect MAX: Imported amounts such as text "120" may not participate as actual numbers. Inspect input cell type and correct the data.
• No numeric entries: Do not use an empty or all-text range as evidence of a real maximum; verify numeric coverage with =COUNT(B2:B8) before interpreting the result.
• Dates and durations: MAX can compare homogeneous dates or homogeneous durations under Apple’s rules; mixed types are not interchangeable.
• Need the largest value meeting a condition: Use MAXIFS, with aligned ranges and carefully chosen condition text. Apple’s no-match result is zero.
• Unexpected error: Check table/range references, separator for your locale, brackets and type mismatches. No Apple Numbers error code was observed in this batch.

Apple’s English syntax uses commas between arguments. If your decimal separator is a comma, Apple’s Functions overview instructs you to type semicolons between function arguments instead. The one-range formulas here need no argument separator. To reference a different table, use Numbers’ explicit Orders::B2:B8-style reference when needed; from another sheet, Numbers can use Sheet Name::Orders::B2:B8. Select cells in the formula editor if a table or sheet name needs quoting or the name is ambiguous. Excel-style Orders!B2:B8 is not the equivalent Numbers syntax.

Official evidence: Functions overview and Refer to cells in formulas.

The function name and basic purpose also exist in Microsoft Excel, Google Sheets and LibreOffice Calc, but do not paste a cross-table reference unchanged: Numbers uses table-qualified forms such as Orders::B2:B8, whereas Excel and Sheets typically qualify worksheet references differently. Argument separator requirements depend on the application and locale. Numbers also documents date/time and duration input rules; do not presume that another application accepts or displays those mixed types in precisely the same way. Check the destination application’s behaviour with representative data before migrating a workbook.

• COUNTIF — count matching order statuses
• COUNTIFS — count records passing multiple tests
• SUMIFS — add amounts subject to multiple criteria
• Related guides: MIN, MAX, and COUNT.

• Apple MAX function reference — definition, signature, optional arguments, ignored referenced text/booleans, date/duration restrictions.
• Apple Functions overview — syntax typography, required/optional arguments, regional separators.
• Apple cell and table references — local ranges and Table::Cell/Sheet::Table::Cell forms.
• Apple Formulas and Functions Help — documented in-app Functions Browser context.
• Apple MAXIFS — filtered maxima, matching-range sizing, zero for no criteria matches.
• Apple MIN — complementary function used for the max-minus-min spread.

• Apple Numbers — function documentation
• Apple MAXIFS
• Functions overview
• Refer to cells in formulas
• Apple Formulas and Functions Help
• Apple MIN

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.