Excel MAX function

Function              MAX

Description        Excel MAX function returns the largest value (numeric) in an array.

Syntax  MAX(number1, [number2], …)

number1  Number, reference or range that contains numeric values.

number2  [optional] Number, reference or range that contains numeric values.

Example:

Usage Notes:

  • The MAX function doesn’t include empty cells.
  • The MAX function accepts up to 255 arguments.
  • The MAX function doesn’t accept logical values. To include logical values in a reference, see the MAXA function.

Related Video Tutorials: