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.