MAX Function


MAX function in Excel is used to find the ‘Largest Number or most recent Date’ from a set of values. MAX function ignores empty cells, the logical values and text values.


Get the largest value in a set of values

Return value

Number equivalent to the Largest Number or recent Date


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


number1 – can be a direct value, cell reference or range reference.

number2 – [optional] can be a direct value, cell reference or range reference

Example 1

Example 2


The MAX function can handle up to 255 arguments.

The MAX function ignores empty cells.

The MAX function ignores TRUE and FALSE values, and numbers entered as text. To consider logical values, MAXA function should be used.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel