MAX

The MAX function returns the largest number in a set of values. Cell references are also accepted as arguments.

Syntax

max(value1,[value2]....)

Arguments

value1 - The numbers or names, arrays, or references that contain numbers. This is a required argument.

value2... - The numbers or names, arrays, or references that contain numbers. This is an optional argument.

Example

max(COLUMN1,COLUMN2,COLUMN3)

Returns the maximum of COLUMN1, COLUMN2 and COLUMN3

Excel Equivalent

MAX