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
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | MAX(number1, [number2], ...) |
| Google Sheets | ✔ Built in | MAX(value1, [value2, ...]) |
| Airtable | ✔ Built in | MAX(number1, [number2, ...])Compares fields of one record. Across linked records, use a rollup with MAX(values). |
| Notion | ✔ Built in | max(number | list, ...)Also works on rollups and lists: max(prop("Scores")). |
| Excel | =MAX(A2:A6) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =MAX(A2:A6) | open sheets.new ↗ |
| Airtable | MAX(42, -7.5, 18, 0, 103) | |
| Notion | max([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
| Argument | What it means |
|---|---|
number1 | The first number, cell or range. |
[number2], ... optional | More numbers or ranges. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=MAX(42, -7.5, 18, 0, 103) | 103 | ||
=MAX(0, A2-B2) | Never below 0 | A floor: returns the difference, or 0 when it would be negative. | |
=MAX(C2:C100) | Latest date | Dates are serial numbers, so MAX finds the most recent. | |
=MAXIFS(B2:B10, A2:A10, "East") | Largest East value | MAXIFS (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).