The Excel MAX function returns the largest value from a supplied set of numerical values.
Syntax: MAX( number1, [number2], … )
where the number arguments are a set of one or more numeric values, or arrays of numeric values, that you want to return the largest value of. These values can be supplied either directly to the function, as cells containing numeric values, or as values returned from other excel formulas.
In Excel 2007 & Excel 2010, you can provide up to 255 number arguments to the Max function, but in Excel 2003 or earlier, you can only provide up to 30 number arguments. If an argument is supplied to the function as a reference to a cell, or an array of cells, the Max function will ignore blank cells, and text or logical values contained within the supplied cell range. However, logical values and text representations of numbers that are supplied directly to the function will be included.
Excel Max Function Example
The following example shows the Max function used to retrieve the largest value from the set of values in cells B3 – B8. The format of the function is shown in the spreadsheet on the left and the resulting value is shown in the spreadsheet on the right.
Max Function Error
If you get an error from the Excel Max Function, this is likely to be the #VALUE! error occurs if any of the arguments are supplied directly to the function and cannot be recognised as numeric values.