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

Last updated