Returns the largest from the specified arguments.
Syntax Copy Code |
---|
MAX( Number n1, [Number n2], ... ) → Number |
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.
Formula Copy Code |
---|
=MAX(A1:A5) |
Function Reference
MAXA Function
MIN Function
MINA Function