Beginner
Statistical
MAX
Returns the largest value in a set of numbers.
Compatibility: All Excel versions
Syntax
=MAX(number1, [number2], ...)
Example
=MAX(A1:A20)
When to Use It
Use MAX to find the highest value in a range — the top sale, the highest score, the latest (largest) date.