Excel MAX Function (Example + Video)
When to use Excel MAX Function
MAX function can be used when you want to get the largest value from a set of values.
What it Returns
It returns the largest value from a set of values.
Syntax
=MAX(number1, [number2], …)
Input Arguments
- number1 – the first number from a set of values from which you want to get the maximum value.
- [number2], .. – (optional) second number from a set of values from which you want to get the maximum value. Up to 255 arguments can be used in the MAX function.
Additional Notes
- Empty cells, logical values, or text in the array or reference are ignored.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
- 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).
Excel MAX Function – Live Example
Excel MAX Function – Video Tutorial
Related Excel Functions:
- Excel INT Function.
- Excel MOD Function.
- Excel RAND Function.
- Excel RANDBETWEEN Function.
- Excel ROUND Function.
- Excel RANK Function.
- Excel LARGE Function.
- Excel MIN Function.
- Excel SMALL Function.
Other articles you may also like: