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:

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

MAX function in Excel 1

  • 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

MAX function in Excel 2

previous-small MAX Function in Excel                                                                                                                next_small MAX Function in Excel