Using the Excel MAX Function

Summary
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.
Syntax
=MAX (number1, [number2], ...)Syntax Breakdown
Number 1Required. 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.