MAX

Get the maximum value in a set of numbers.

Parameter List

Syntax
MAX(value1
[value2]
)
value1

A number, cell, range, or JSON arrays to include in the max calculation. For example: 7, A3, or A1:A20.

[optional] value2

Additional numbers, cells, ranges, or JSON arrays to include in the max calculation. For example: 9, B3, or B1:B20.

Examples

MAX(A1:A3) returns 3, as it's the largest number in the range.