- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Statistical - MAX Function
Description
The MAX function returns the largest value in a set of values.
Syntax
MAX (number1, [number2] ...)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Number1 | 1 to 255 numbers for which you want to find the maximum value | Required |
Notes
Arguments can either be numbers or names, arrays, or references that contain numbers.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
If the arguments contain no numbers, MAX returns 0 (zero).
If any values that are supplied directly to the MAX Function are non-numeric, MAX returns the #VALUE! Error.
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MAXA function.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016