The MAX function returns the largest value from a supplied set of numerical values.
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
|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.
Note: 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.
|2||4||=MAX(A2:A6)||5||Retrieves the largest value from a set of values|
Excel MAX and MAXA Functions
The Excel MAX and MAXA functions are very similar. The difference is, when an argument is supplied to the function as a reference to a cell or an array of cells:
- MAX ignores logical and text values
- MAXA counts the logical value TRUE as 1, the logical value FALSE as 0 and text values as 0
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if any of the arguments are supplied directly to the function and cannot be recognized as numeric values|