Excel MAX Function

Using the Excel MAX Function


The Excel MAX function will return the largest numeric value from a range of values. The function ignores TRUE/FALSE, text values, and empty cells.

To find the smallest number from a range of values, use the MIN function.


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

Syntax Breakdown

Number 1
Required. The number for which you want to find the maximum value. The argument can be a number, name, array, or cell reference.

Logical values, such as TRUE and FALSE, and numbers entered as text are ignored, unless they are entered directly into the list of arguments.

Number 2
Number 2 and subsequent arguments are optional. The function can accept up to 255 arguments.

Usage Notes

MAX returns the largest value from a set of provided values. The function ignores empty cells, text values, and logical values. The function returns 0 (zero) if the arguments contains no numbers.

Arguments with error values or text that cannot be translated into a number will cause an error.

Use the MAXA function if you would like to include logical values and text representations of numbers.