MAX

The MAX function returns the largest number in a set of values. Node 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