MAX Function - Excel
Overview
The MAX function in Excel is a useful tool for finding the highest value in a range of cells. The function will return the maximum (largest) value from a specified set of values. You can provide up to 255 arguments.
Example:
=MAX(3, 400, 25)
Syntax:
=MAX(number1, [number2], ...)
number1, number2, ...: These are the values or ranges that you want to find the maximum value from.
Example
In the example above, the MAX function takes in cells C2 through C11 and returns the largest value, which is 500.