Quick Answer
MAX Function
MAX finds the highest value in a range.
✓ Excel✓ Google SheetsExcel All versions
Syntax
MAX
(number1, [number2], ...)
Parameters
| Parameter | Description | Required |
|---|---|---|
| number1 | The first number, cell reference, or range. | Required |
| number2 | Optional additional numbers, cell references, or ranges. | Optional |
Basic Example
Find the highest value in a range
=MAX(A1:A10)Result95
Returns the largest number from cells A1 through A10.
Advanced Examples
Example 1: Max with criteria using MAXIFS
Conditional maximumFind the maximum value that meets specific criteria
=MAXIFS(A1:A10, B1:B10, "Region A")Result: 88
MAXIFS finds the highest value in column A where column B matches "Region A".
How MAX Works
MAX scans all numeric values in the specified range and returns the largest one, ignoring text, blank cells, and logical values.
1
Select output cell
Choose where the result should appear.
2
Enter formula
Type =MAX(range).
3
Press Enter
The result shows the maximum value.
Important Notes & Limitations
MAX ignores text and blank cells.
For conditional maximums, use MAXIFS.
Common Errors & Fixes
#VALUE!No numeric values foundFix: Check your data range contains numbers.
Download Practice File
MAX
maxPractice MAX with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the MAX function. Works in both Excel and Google Sheets.
Works in Google SheetsCompatible with ExcelIncludes exercises
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Frequently Asked Questions
Does MAX consider dates?
Yes, dates are stored as serial numbers, so MAX can find the latest date.
What if all cells are empty?
MAX returns 0 if all cells are empty.