The MAX function returns the largest value from a supplied set of numerical values.

Syntax

=MAX(num_1,[num_2],…)

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.

Arguments

Argument Description
num_1,
[num_2], …
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.

  Numbers can be supplied either directly to the function, as cells containing numeric values, or as values returned from other excel formulas

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.

Examples

  A B C D
1 Value Formula Result Notes
2 4 =MAX(A2:A6) 5 Retrieves the largest value from a set of values
3      
4 1      
5 5      
6 2      
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