Returns the largest from the specified arguments.

Syntax  Copy Code
MAX( Number n1, [Number n2], ... ) → Number

Parameters

n1
n2
…

One or more numbers for which to find the maximum value.

Remarks

The arguments can be either numbers, or cells or arrays that contain numbers. Logical values, text, and empty cells are ignored. To consider logical values and text, use the MAXA function.

Example

Formula  Copy Code
=MAX(A1:A5) =MAX(A1:A5,25)

See Also

Function Reference
MAXA Function
MIN Function
MINA Function