Microsoft Excel MAX Function Help

MAX Function Examples

• Click to view MAX function examples

MAX Function Definition

Returns the largest value from a worksheet range or set of values.

MAX Function Syntax

=MAX(number1,number2,...)

MAX Function Argument Definitions

number1, number2, ...:  These are 1 to 30 numbers for which you want to find the maximum value. They can be cell references like A1, range references like A1:A10 or cell names and range names. They can even be formulas and other functions.

MAX Function Tips

• The arguments for this function can either be numbers or names, arrays, or range references that contain numbers.
• You can type logical values and text representations of numbers directly into the argument list and they will be counted.
• If an argument is range reference or an array, only numbers the numbers are analyzed. Empty cells, logical values and text are ignored.
• Any arguments that produce error values or text that cannot be translated into numbers can cause errors.
• If you want to include logical values and text representations of numbers in a reference as part of the calculation, try using the MAXA function.