MAX

The MAX function returns the largest value in a set of values.

Syntax

=MAX(number1, [number2], ...)

Parameters

• number1: The first number to compare
• number2, ...: Optional. Additional numbers to compare

Examples

=MAX(10, 20, 30) // Returns 30
=MAX(-5, 0, 5) // Returns 5
=MAX(100) // Returns 100