Functions
MAX
Maximum value
Try it
When to use it
When should I use MAX instead of LARGE?
Use MAX for the single highest value; use LARGE when you need the second-highest, third-highest, and so on.
Does MAX ignore text and blanks?
Yes. MAX considers only numeric values and skips text and empty cells.
Use cases
Get the peak value from a list
Identify the top revenue figure
Used in
operations · science · finance
Syntax
MAX(value1,...)Examples
=MAX(1,2,3,4,5) // => 5
=MAX({1,2,3},{4,5,6},4,26) // => 26