The MAX function in Excel returns the largest number from a group of values. It is one of the most useful basic functions for identifying top values like highest sales, largest expenses, best scores, or maximum quantities.
If you’re working with lists of numbers, MAX gives you a fast and reliable way to find the highest value without sorting your data.
In this guide, you’ll learn:
- What the MAX function does
- How to use MAX step-by-step
- How to find the highest number in a range
- How MAX handles blank cells and text
- Common mistakes to avoid
- Real-world uses for the MAX function
The MAX function finds and returns the largest numeric value from a group of numbers.
For example, if you have sales amounts:
120
450
310
275
The MAX function returns:
450
Because 450 is the largest number in the list.
MAX Function Syntax
The syntax for MAX is simple:
=MAX(number1, [number2], ...)
Arguments:
- number1 — The first number or range
- number2 — Additional numbers or ranges (optional)
Most commonly, you’ll use MAX with a range of cells.
Example:
=MAX(A2:A10)
This finds the largest value in cells A2 through A10.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> MAX Function Data
How to Use the MAX Function
Let’s walk through a basic example.
Click in cell B7 and type:
=MAX(B2:B5)
Press Enter.
Excel returns 450
How MAX Handles Blank Cells and Text
The MAX function automatically ignores blanks and text.
MAX returns 275 because it only evaluates numeric values.
Using MAX with Multiple Ranges
You can include multiple ranges in one formula.
Example:
=MAX(B2:B5, C2:C5)
This finds the largest value across both ranges.
This is useful when data is stored in separate sections of a worksheet.
Using MAX with Individual Numbers
You can also enter numbers directly.
Example:
=MAX(10, 45, 22, 90)
The result is 90.
This is less common but useful for quick comparisons.
Common MAX Mistakes to Avoid
Here are some common errors users make.
Mistake 1 — Selecting the Wrong Range
Example:
=MAX(B2:B4)
Instead of:
=MAX(B2:B5)
This excludes data and gives an incorrect result. Always double-check your selected range.
Mistake 2 — Including Header Text
Example:
=MAX(B1:B5)
If B1 contains text, Excel ignores it — but it’s best practice to exclude headers.
Correct:
=MAX(B2:B5)
Mistake 3 — Expecting MAX to Return Text
MAX only evaluates numbers, not text.
If your numbers are stored as text, MAX will ignore them.
Real-World Uses for the MAX Function
The MAX function is widely used in real-world spreadsheets.
Examples include:
- Finding the highest monthly sales
- Identifying the top test score
- Determining the largest expense
- Tracking the maximum inventory level
- Finding the highest temperature recorded
If your goal is to identify the largest value, MAX is the right tool.
MAX vs MIN — What’s the Difference?
MAX and MIN are closely related functions.
- MAX returns the largest number
- MIN returns the smallest number
Example:
=MAX(B2:B5) → 450
=MIN(B2:B5) → 120
Together, they help identify the range of values in a dataset.
When Should You Use the MAX Function?
Use MAX when you need to:
- Find the largest value in a list
- Identify peak values
- Highlight top performance
- Monitor limits or thresholds
- Build dashboards and summaries
MAX is one of the most commonly used Excel functions, especially in reporting and analytics.
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> MAX Function Data
