Spreadsheet formulas explained, side by side

MAX Function in Excel, Google Sheets, Airtable & Notion

MAX returns the largest number among its arguments. Blank cells and text in a range are ignored, and it returns the latest date in a range of dates.

Syntax in each app

AppSupportSyntax & notes
Excel✔ Built inMAX(number1, [number2], ...)
Google Sheets✔ Built inMAX(value1, [value2, ...])
Airtable✔ Built inMAX(number1, [number2, ...])
Compares fields of one record. Across linked records, use a rollup with MAX(values).
Notion✔ Built inmax(number | list, ...)
Also works on rollups and lists: max(prop("Scores")).
Try MAX with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
103
Your formula, ready to paste
Excel=MAX(A2:A6) open excel.new ↗
Google Sheets=MAX(A2:A6) open sheets.new ↗
AirtableMAX(42, -7.5, 18, 0, 103)
Notionmax([42, -7.5, 18, 0, 103])

Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.

Value
42
-7.5
18
0
103

Arguments

ArgumentWhat it means
number1The first number, cell or range.
[number2], ... optionalMore numbers or ranges.

Examples

FormulaResultWhyCopy
=MAX(42, -7.5, 18, 0, 103)103
=MAX(0, A2-B2)Never below 0A floor: returns the difference, or 0 when it would be negative.
=MAX(C2:C100)Latest dateDates are serial numbers, so MAX finds the most recent.
=MAXIFS(B2:B10, A2:A10, "East")Largest East valueMAXIFS (Excel 2019+, Sheets) adds conditions.

Examples use Excel / Google Sheets syntax unless noted.

How MAX works

MAX returns the highest number in its arguments, skipping empty cells, text and logical values inside ranges. With no numbers at all it returns 0. A neat trick is using MAX as a floor: =MAX(0, A2-B2) can never go negative, which is handy for “amount still owed” or “days overdue”. MIN does the reverse and caps a value.

For the second- or third-largest value use LARGE; for the largest value that meets a condition use MAXIFS (Excel 2019 and later, Google Sheets). To find which row holds the maximum, combine it with lookups: =INDEX(A2:A10, MATCH(MAX(B2:B10), B2:B10, 0)) returns the name next to the highest score (see INDEX + MATCH).

In Airtable, MAX({Bid 1}, {Bid 2}) works within a record and a rollup with MAX(values) works across linked records; MAX of a date rollup gives the latest date. Notion's max() accepts numbers or lists.

Frequently Asked Questions

How do I stop a result going below zero?
Wrap it in MAX: =MAX(0, your_formula).
How do I find the name of the person with the highest score?
Use =INDEX(names, MATCH(MAX(scores), scores, 0)) or =XLOOKUP(MAX(scores), scores, names).

Part of the Statistics & Counting functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.