MAX Function in Excel – Get the Maximum value in Excel

MAX function in Excel returns the largest value or maximum value from a supplied set of numeric values.

Syntax of MAX Function in Excel:

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

Result