MAX Function

Summary

MAX returns the largest number in a set of values. It is one of the quickest ways to answer a simple question in Excel: what is the highest number here?

That sounds basic, but it is useful in a lot of real sheets. You can use it to find the top sales day, the biggest expense, the highest score, the warmest temperature, or even the latest date because Excel stores dates as numbers too.

MAX is useful whenever the workbook needs the upper edge of a set. It quickly identifies the highest value, which makes it practical in scoreboards, threshold checks, pricing analysis, and any model where the peak result matters.

Syntax

=MAX(number1, [number2], ...)

You can use a range like A1:A10, list separate cells, or type numbers directly into the formula. Excel allows up to 255 arguments.

Arguments

• number1 - [required] The first number, cell reference, range, or array to check.
• number2, ... - [optional] More numbers, references, ranges, or arrays to include.

MAX vs Other Functions

Using the MAX Function

MAX is useful because it keeps the answer focused. When you need the top result, there is no need to sort the whole table or scan it by eye. One formula can return the highest number right away, and it updates automatically if the data changes.

Microsoft points out an important detail here. If you type logical values or text versions of numbers directly into the argument list, Excel counts them. But if those values are inside a range or reference, MAX only uses the numeric entries and ignores text, logical values, and empty cells. If you want logical values and text numbers in references to count too, use MAXA instead.

Another small detail that is easy to forget is that MAX can work with dates. Since Excel stores dates as serial numbers, the latest date in a range is also the maximum date in that range. That makes MAX useful beyond sales and scores.

Example 1 - Find the highest sale in a range

This is the usual pattern. You point MAX at a block of numbers and let Excel return the top one.

This is a useful starting example because it shows the main job of MAX very directly: find the single largest value without sorting the whole list.

=MAX(B1:B5) // Returns the highest value in the range.

Example 2 - Compare numbers typed directly in the formula

MAX also works for quick manual comparisons when you do not want to place every value in cells first.

This helps show that the function is useful even outside a worksheet range. You can still use it as a quick comparison tool for a few values.

=MAX(10,50,20) // Returns 50.

Example 3 - Pull the highest score from a list

In a score table, MAX gives you the top result immediately, which is useful for dashboards and simple summaries.

This is practical because the formula answers a common reporting question fast: what is the best result in the list right now?

=MAX(B1:B10) // Returns the highest score in the range.

Example 4 - Track the peak number in a larger set

The same idea works for production totals, response times, temperatures, prices, or dates.

This helps the learner see that MAX is not tied to one kind of data. Any situation with a “highest value” question can use the same pattern.

=MAX(B1:B10) // Returns the largest value in the range.

Conclusion Recap

MAX is the quick answer when your real question is simply "which value is the highest?" In this lesson, that could be the biggest sale, top score, highest price, or even the latest date.

You can point it at a range, compare separate cells, or type values directly. As long as Excel can see the numbers, MAX pulls out the top one without needing any sorting.

• Main job: MAX returns the largest number in a list.
• Flexible input: You can use ranges, separate references, arrays, or typed values.
• Reference behavior: In ranges, text, logical values, and blanks are ignored.
• No numeric values: If Excel finds no numbers, MAX returns 0.
• Dates work too: The latest date in a range is also the maximum date.
• Related option: Use MAXA if you need logical values and text numbers in references included.