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.

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.

=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.

=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.

=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.

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

Conclusion Recap

• 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.