MAX function

Category: Statistical functions

What does this function do?

Returns the maximum value in a list of values. Ignores logical values and text.

Syntax:

MAX(number1,number2,...)

• number1 (required): The first of the values or ranges to evaluate.
• number2 (optional): From the second number or range parameters are optional.

Examples:

=MAX(1, 2, 3) = 3
=MAX(A1:A2,B1:B2) = 3, if A1:A2= {1,2} and B1:B2= {2,3}