MAX

See also A-Z Spreadsheet Function List

Description Returns the largest value in the specified list of numbers.

Syntax MAX(number_list)

number_list is a list of as many as 30 numbers, separated by commas.

The list can contain numbers, logical values, text representations of numbers, or a reference to a range containing those values.

Error values or text that cannot be translated into numbers return errors.

If a range reference is included in the list, text, logical expressions, and empty cells in the range are ignored.

If there are no numbers in the list, 0 is returned.

See Also AVERAGE and MIN functions

Examples MAX(50, 100, 150, 500, 200) returns 500

         MAX(A1:F12) returns the largest value in the range