MAX

Calculates the maximum value of specified numbers.

Syntax

=MAX(number1, number2, ..., numberN)

=MAX(numberArray)

Arguments

Argument	Type	Description
number	Number or Array	A number or array of numbers to find the maximum of

📘

If an array of values is supplied, the array will be flattened when averaging. For example, =MAX(ARRAY(1,ARRAY(2,3)),ARRAY(4,5),6) returns 6.

Examples

=MAX(1,2,3) → 3
Calculates the maximum of 1, 2, and 3.

=MAX(ARRAY(4,5),6) → 6
Calculates the maximum of any array containing 4, 5 and the number 6. Because the MAX function flattens arrays, this is the same as the maximum of 4, 5, and 6.

=MAX(children."Property 1") → 8
Calculates the maximum of all children's data property values for "Property 1" (1, 4, 2, 6, 7, 8).