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: