MAX function in Excel returns the largest value or maximum value from a supplied set of numeric values.
Syntax of MAX Function in Excel:
MAX( number1, [number2], … )
Where the number arguments are one or more numeric values from which you want to find the maximum value in Excel
Example of MAX Function in Excel:
Formula
- Text and Logical values are ignored by Excel MAX Function
- In First Example Max Function takes up the cell reference and finds the maximum value
- In Second Example Max Function takes up the values directly and finds the maximum value