MAX function

MAX returns the maximum value in a list of arguments.

MAX returns 0 if no numeric value and no error was encountered in the cell ranges passed as cell references. Text cells are ignored by MAX(). The function MAXA() returns 0 if no value (numeric or text) and no error was encountered. Passing a literal string argument to MAX(), for example, MAX("string"), results in an error.

Syntax

MAX(number1,number2, ...number30)

number 1, number 2, and so on, up to number 30 are numeric values or ranges.

Example

=MAX(A1,A2,A3,50,100,200) returns the largest value from the list.

=MAX(A1:B100) returns the largest value from the list.